Skip to main content

table_properties

Overview​

Used to view attribute information of tables (including internal and external tables).

Database​

information_schema

Table Information​

Column NameTypeDescription
TABLE_CATALOGvarchar(64)The Catalog to which the table belongs
TABLE_SCHEMAvarchar(64)The Database to which the table belongs
TABLE_NAMEvarchar(64)The name of the table
PROPERTY_NAMEstringThe name of the property
PROPERTY_VALUEstringThe value of the property