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

• This command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands).

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), KEY(b) USING CLUSTERED COLUMNSTORE);

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'

Was this Article Helpful?

Thanks For Your Feedback!