SHOW-CREATE-TABLE

Name

SHOW CREATE TABLE

Description

This statement is used to display the creation statement of the data table.

grammar:

1. SHOW [BRIEF] CREATE TABLE [DBNAME.]TABLE_NAME

illustrate:

SinceVersion dev

  1. BRIEF : will not show partitions info
  2. DBNAMNE : database name
  3. TABLE_NAME : table name

Example

  1. View the table creation statement of a table

1. SHOW CREATE TABLE demo.tb1

Keywords

1. SHOW, CREATE, TABLE

Best Practice