tencent cloud

Data Lake Compute

SHOW TBLPROPERTIES

Download
Focus Mode
Font Size
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');


Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback