SHOW CREATE TABLE

On this page Carat arrow pointing down
Warning:
As of November 10, 2018, CockroachDB v1.0 is no longer supported. For more details, refer to the Release Support Policy.

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