tencent cloud

SHOW TBLPROPERTIES
Last updated: 2024-08-07 17:13:21
SHOW TBLPROPERTIES
Last updated: 2024-08-07 17:13:21

Description

Supported engines: Presto and SparkSQL
Applicable table: Native and external tables
Purpose: List table attributes.

Statement

SHOW TBLPROPERTIES table_name [('property_name')]

Parameter

[('property_name')]: If the attribute exists, list only the attribute name and value.

Example

SHOW TBLPROPERTIES tb1;
SHOW TBLPROPERTIES orders('tb1');

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback