SHOW CREATE TABLE

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

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

Syntax

SHOW CREATE TABLE { table_name | view_name }

Parameters

table_name

Identifies the table. 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')