SHOW-CREATE-TABLE
Name
SHOW CREATE TABLE
Description
This statement is used to display the creation statement of the data table.
Syntax:
SHOW CREATE TABLE [DBNAME.]TABLE_NAME
Note:
DBNAMNE
: database nameTABLE_NAME
: table name
Example
-
View the table creation statement of a table
SHOW CREATE TABLE demo.tb1
Keywords
SHOW, CREATE, TABLE