SHOW CREATE TABLE

Shows the CREATE TABLE statement that was used to create the table.

Syntax

SHOW CREATE TABLE table_name

Arguments

table_name

The name of the table.

Remarks

Examples

Example 1

The following example shows the output of SHOW CREATE TABLE for a rowstore table with sparse compression.

Create the table:

CREATE ROWSTORE TABLE table_1(a INT, b DECIMAL) COMPRESSION = SPARSE;

Show the table:

SHOW CREATE TABLE table_1;

Output of the Create Table column for the table_1 row:

CREATE ROWSTORE TABLE `table_1` (
  `a` int(11) DEFAULT NULL,
  `b` decimal(10,0) DEFAULT NULL
  , SHARD KEY () 
) AUTOSTATS_CARDINALITY_MODE=PERIODIC AUTOSTATS_HISTOGRAM_MODE=CREATE SQL_MODE='STRICT_ALL_TABLES'
  COMPRESSION=SPARSE

Example 2

The following example shows the output of SHOW CREATE TABLE for a columnstore table.

Create the table:

CREATE TABLE table_2(a INT, b VARCHAR(50), SORT KEY(b));

Show the table:

SHOW CREATE TABLE table_2;

Output of the Create Table column for the table_2 row:

CREATE TABLE `table_2` (
  `a` int(11) DEFAULT NULL,
  `b` varbinary(50) DEFAULT NULL,
  KEY `b` (`b`) USING CLUSTERED COLUMNSTORE
  , SHARD KEY () 
) AUTOSTATS_CARDINALITY_MODE=INCREMENTAL AUTOSTATS_HISTOGRAM_MODE=CREATE AUTOSTATS_SAMPLING=ON SQL_MODE='STRICT_ALL_TABLES'

Last modified: January 11, 2023

Was this article helpful?