SHOW CREATE TABLE

On this page Carat arrow pointing down

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

SHOW CREATE TABLE table_name

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)

See Also


Yes No
On this page

Yes No