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 CREATE TABLE [DBNAME.]TABLE_NAME

illustrate:

1. DBNAMNE : database name
2. TABLE_NAME : table name

Example

1. View the table creation statement of a table

   SHOW CREATE TABLE demo.tb1

Keywords

SHOW, CREATE, TABLE

Best Practice