SHOW CREATE TABLE

Applies to: Databricks SQL Databricks Runtime

Note

To use this command on materialized views or streaming tables, you must use Databricks Runtime version 14.1 or above.

Returns the statement that was used to create a given table or view. The returned statement can be any of the following types:

• CREATE TABLE
• CREATE VIEW

• CREATE MATERIALIZED VIEW
• CREATE STREAMING TABLE

SHOW CREATE TABLE on a temporary view, a metric view, or non-existent table throws an exception.

Syntax

SHOW CREATE TABLE { table_name | view_name }

Parameters

• table_name

  Identifies the relation. The name must not include a temporal specification or options specification.

Examples

> CREATE TABLE test (c INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    STORED AS TEXTFILE
    TBLPROPERTIES ('prop1' = 'value1', 'prop2' = 'value2');

> SHOW CREATE TABLE test;
                                       createtab_stmt
 ----------------------------------------------------
 CREATE TABLE `default`.`test` (`c` INT)
 USING text
 TBLPROPERTIES (
   'transient_lastDdlTime' = '1586269021',
   'prop1' = 'value1',
   'prop2' = 'value2')

Related articles

• CREATE TABLE

• CREATE STREAMING TABLE

• CREATE VIEW

• CREATE MATERIALIZED VIEW

• INFORMATION_SCHEMA.COLUMNS
• INFORMATION_SCHEMA.TABLES
• INFORMATION_SCHEMA.VIEWS