RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-aux-show-create-table below:

SHOW CREATE TABLE | Databricks Documentation

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, 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â

SQL

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