Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Shows the CREATE TABLE
statement that was used to create the table.
SHOW CREATE TABLE table_name
table_name
The name of the table.
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
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'