VeloDB Cloud
SQL Manual
Statments
Show-Statements
SHOW-CREATE-TABLE

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:

  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