Skip to main content
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