Share via

SHOW CREATE TABLE

  • Article

Applies to: check marked yes Databricks SQL check marked yes 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:

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

Syntax

SHOW CREATE TABLE { table_name | view_name }

Parameters

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')