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