On this page 
The SHOW CREATE TABLE statement shows the CREATE TABLE statement that would create a carbon copy of the specified table.
Required Privileges
The user must have any privilege on the target table.
Synopsis
Parameters
| Parameter | Description |
|---|---|
table_name | The name of the table for which to show the CREATE TABLE statement. |
Response
| Field | Description |
|---|---|
Table | The name of the table. |
CreateTable | The CREATE TABLE statement for creating a carbon copy of the specified table. |
Example
> CREATE TABLE orders ( id INT PRIMARY KEY DEFAULT unique_rowid(), date TIMESTAMP NOT NULL, priority INT DEFAULT 1, customer_id INT UNIQUE, status STRING DEFAULT 'open', CHECK (priority BETWEEN 1 AND 5), CHECK (status in ('open', 'in progress', 'done', 'cancelled')), FAMILY (id, date, priority, customer_id, status) ); > SHOW CREATE TABLE orders; +--------+--------------------------------------------------------------------------------------------------+ | Table | CreateTable | +--------+--------------------------------------------------------------------------------------------------+ | orders | CREATE TABLE orders ( | | | id INT NOT NULL DEFAULT unique_rowid(), | | | date TIMESTAMP NOT NULL, | | | priority INT NULL DEFAULT 1, | | | customer_id INT NULL, | | | status STRING NULL DEFAULT 'open', | | | CONSTRAINT "primary" PRIMARY KEY (id), | | | UNIQUE INDEX orders_customer_id_key (customer_id), | | | FAMILY fam_0_id_date_priority_customer_id_status (id, date, priority, customer_id, status), | | | CHECK (priority BETWEEN 1 AND 5), | | | CHECK (status IN ('open', 'in progress', 'done', 'cancelled')) | | | ) | +--------+--------------------------------------------------------------------------------------------------+ (1 row)