Show Create Table¶
The SHOW CREATE TABLE statement prints the CREATE TABLE statement of an
existing user-created doc table in the cluster:
cr> show create table my_table;
+-----------------------------------------------------+
| SHOW CREATE TABLE doc.my_table |
+-----------------------------------------------------+
| CREATE TABLE IF NOT EXISTS "doc"."my_table" ( |
| "first_column" INTEGER NOT NULL, |
| "second_column" TEXT, |
| "third_column" TIMESTAMP WITH TIME ZONE, |
| "fourth_column" OBJECT(STRICT) AS ( |
| "key" TEXT, |
| "value" TEXT |
| ), |
| PRIMARY KEY ("first_column") |
| ) |
| CLUSTERED BY ("first_column") INTO 5 SHARDS |
| WITH ( |
| "allocation.max_retries" = 5, |
| "blocks.metadata" = false, |
| "blocks.read" = false, |
| "blocks.read_only" = false, |
| "blocks.read_only_allow_delete" = false, |
| "blocks.write" = false, |
| codec = 'default', |
| column_policy = 'strict', |
| "mapping.total_fields.limit" = 1000, |
| max_ngram_diff = 1, |
| max_shingle_diff = 3, |
| "merge.scheduler.max_thread_count" = 1, |
| number_of_replicas = '0-1', |
| "routing.allocation.enable" = 'all', |
| "routing.allocation.total_shards_per_node" = -1, |
| "store.type" = 'fs', |
| "translog.durability" = 'REQUEST', |
| "translog.flush_threshold_size" = 536870912, |
| "translog.sync_interval" = 5000, |
| "unassigned.node_left.delayed_timeout" = 60000, |
| "write.wait_for_active_shards" = '1' |
| ) |
+-----------------------------------------------------+
SHOW 1 row in set (... sec)
The table settings returned within the WITH clause of the result are all
available table settings showing their respective values at the time of the
execution of the SHOW statement.
Different versions of CrateDB may have different default table settings. This
means that if you re-create the table using the resulting CREATE TABLE
statement the settings of the ‘old’ table may differ from the settings of the
‘new’ table. This is because the table settings are set explicitly on creation
time.