Skip to main content
Skip to main content

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​