On this page 
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
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
Was this helpful?
