ContextQMD
Back to Presto

SHOW CREATE TABLE

presto-docs/src/main/sphinx/sql/show-create-table.rst

0.297717 B
Original Source

================= SHOW CREATE TABLE

Synopsis

.. code-block:: none

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;

.. code-block:: none

              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

:doc:create-table