In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands. SHOW is a command that displays information about active connections and database objects.
In order to get the CREATE TABLE statement, use the following command.
SHOW CREATE TABLE [database_name].table_name
In order to get the CREATE VIEW statement, use the following command.
SHOW CREATE VIEW [database_name].view_name
In order to get the CREATE FUNCTION statement, use the following command. (Ref)
SHOW CREATE FUNCTION [database_name].function_name
The statement SHOW CREATE DATABASE isn’t accessible. However, there is a workaround that will be described in more detail in future publications.
Hope you find this article helpful.
Please subscribe for more interesting updates.