SHOW CREATE TABLE

On this page Carat arrow pointing down

The SHOW CREATE TABLE statement shows the CREATE TABLE statement that would create a 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 copy of the specified table.

Example

> CREATE TABLE customers (id INT PRIMARY KEY, email STRING UNIQUE);
> CREATE TABLE products (sku STRING PRIMARY KEY, price DECIMAL(9,2));
> CREATE TABLE orders (
    id INT PRIMARY KEY,
    product STRING NOT NULL REFERENCES products,
    quantity INT,
    customer INT NOT NULL CONSTRAINT valid_customer REFERENCES customers (id),
    CONSTRAINT id_customer_unique UNIQUE (id, customer),
    INDEX (product),
    INDEX (customer)
);
> SHOW CREATE TABLE customer;
+-----------+----------------------------------------------------+
|   Table   |                    CreateTable                     |
+-----------+----------------------------------------------------+
| customers | CREATE TABLE customers (                           |
|           |     id INT NOT NULL,                               |
|           |     email STRING NULL,                             |
|           |     CONSTRAINT "primary" PRIMARY KEY (id ASC),     |
|           |     UNIQUE INDEX customers_email_key (email ASC),  |
|           |     FAMILY "primary" (id, email)                   |
|           | )                                                  |
+-----------+----------------------------------------------------+
(1 row)
> SHOW CREATE TABLE products;
+----------+--------------------------------------------------+
|  Table   |                   CreateTable                    |
+----------+--------------------------------------------------+
| products | CREATE TABLE products (                          |
|          |     sku STRING NOT NULL,                         |
|          |     price DECIMAL(9,2) NULL,                     |
|          |     CONSTRAINT "primary" PRIMARY KEY (sku ASC),  |
|          |     FAMILY "primary" (sku, price)                |
|          | )                                                |
+----------+--------------------------------------------------+
(1 row)
> SHOW CREATE TABLE orders;
+--------+------------------------------------------------------------------------------------------+
| Table  |                                       CreateTable                                        |
+--------+------------------------------------------------------------------------------------------+
| orders | CREATE TABLE orders (                                                                    |
|        |     id INT NOT NULL,                                                                     |
|        |     product STRING NOT NULL,                                                             |
|        |     quantity INT NULL,                                                                   |
|        |     customer INT NOT NULL,                                                               |
|        |     CONSTRAINT "primary" PRIMARY KEY (id ASC),                                           |
|        |     UNIQUE INDEX id_customer_unique (id ASC, customer ASC),                              |
|        |     CONSTRAINT fk_product_ref_products FOREIGN KEY (product) REFERENCES products (sku),  |
|        |     INDEX orders_product_idx (product ASC),                                              |
|        |     CONSTRAINT valid_customer FOREIGN KEY (customer) REFERENCES customers (id),          |
|        |     INDEX orders_customer_idx (customer ASC),                                            |
|        |     FAMILY "primary" (id, product, quantity, customer)                                   |
|        | )                                                                                        |
+--------+------------------------------------------------------------------------------------------+
(1 row)

See Also


Yes No
On this page

Yes No