SHOW-CREATE-TABLE
SHOW-CREATE-TABLE
Name
SHOW CREATE TABLE
Description
This statement is used to display the creation statement of the data table.
grammar:
SHOW [BRIEF] CREATE TABLE [DBNAME.]TABLE_NAME
illustrate:
BRIEF
: will not show partitions info
DBNAMNE
: database nameTABLE_NAME
: table name
Example
View the table creation statement of a table
SHOW CREATE TABLE demo.tb1
Keywords
SHOW, CREATE, TABLE