Viewing Table Properties

Function

Check the properties of a table.

Syntax

1

SHOW TBLPROPERTIES table_name [('property_name')];

Keyword

TBLPROPERTIES: This statement allows you to add a key/value property to a table.

Parameters

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