SHOW CREATE TABLE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Shows the CREATE TABLE statement that was used to create the table.
Syntax
SHOW CREATE TABLE table_nameArguments
table_
The name of the table.
Remarks
-
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
-
Beginning with version 7.
3, conditional comments are removed by default. To enable conditional comments, use the show_ with_ portabililty_ comments variable. -
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_ 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=SPARSEExample 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_ 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