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-tblproperties below:

SHOW TBLPROPERTIES | Databricks Documentation

> USE salessc;
> CREATE TABLE customer(cust_code INT, name VARCHAR(100), cust_addr STRING)
    TBLPROPERTIES ('created.by.user' = 'John', 'created.date' = '01-01-2001');


> SHOW TBLPROPERTIES customer;
                   key      value
 
       created.by.user       John
          created.date 01-01-2001
 transient_lastDdlTime 1567554931



> SHOW TBLPROPERTIES salessc.customer;
                   key      value
 
       created.by.user       John
          created.date 01-01-2001
 transient_lastDdlTime 1567554931


> SHOW TBLPROPERTIES customer (created.by.user);
 value
 
  John


> SHOW TBLPROPERTIES customer ('created.date');
      value
 
 01-01-2001

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4