8.30. 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

原文: https://prestodb.io/docs/current/sql/show-create-table.html