Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Viewing Tables> Viewing Table Properties
View PDF

Viewing Table Properties

Function

Check the properties of a table.

Syntax

1
 
SHOW TBLPROPERTIES table_name [('property_name')];

Keyword

property_name: If property_name is not specified in the statement, all attributes and their values are returned. If it is specified, the value corresponding to the specified property_name is returned.

Precautions

property_name is case sensitive. You cannot specify multiple property_name attributes at the same time. Otherwise, an error occurs.

Example

To return the value of property_key1 in the test table, run the following statement:

1
 
SHOW TBLPROPERTIES test ('property_key1');
Parent topic: Viewing Tables