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:
SHOW CREATE TABLE on a temporary view or non-existent table throws an exception.
Syntax
SHOW CREATE TABLE { table_name | view_name }
Parameters
-
Identifies the table. The name must not include a temporal 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')