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)