Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW CREATE TABLE

The SHOW CREATE TABLE command 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

  • Conditional comments are removed by default.

  • See the Permission Matrix for the required permission.

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:

Was this article helpful?