8.36. SHOW CREATE TABLE

Synopsis

  1. 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:

  1. SHOW CREATE TABLE sf1.orders;

  1.               Create Table

CREATE TABLE tpch.sf1.orders ( orderkey bigint, orderstatus varchar, totalprice double, orderdate varchar ) WITH ( format = 'ORC', partitioned_by = ARRAY['orderdate'] )(1 row)

See Also

CREATE TABLE