SHOW CREATE TABLE#
Synopsis#
SHOW CREATE TABLE table_name
Description#
Show the SQL statement that creates the specified table.
Examples#
Show the SQL that can be run to create the orders
table:
SHOW CREATE TABLE sf1.orders;
Create Table
-----------------------------------------
CREATE TABLE tpch.sf1.orders (
orderkey bigint,
orderstatus varchar,
totalprice double,
orderdate varchar
)
WITH (
format = 'ORC',
partitioned_by = ARRAY['orderdate']
)
(1 row)