tables_config

tables_config provides information about the configuration of tables.

The following fields are provided in tables_config:

Field	Description
TABLE_SCHEMA	Name of the database that stores the table.
TABLE_NAME	Name of the table.
TABLE_ENGINE	Engine type of the table.
TABLE_MODEL	Data model of the table. Valid values: DUP_KEYS, AGG_KEYS, UNQ_KEYS or PRI_KEYS.
PRIMARY_KEY	Primary key of a Primary Key table or a Unique Key table. An empty string is returned if the table is not a Primary Key table or a Unique Key table.
PARTITION_KEY	Partitioning columns of the table.
DISTRIBUTE_KEY	Bucketing columns of the table.
DISTRIBUTE_TYPE	Data distribution method of the table.
DISTRIBUTE_BUCKET	Number of buckets in the table.
SORT_KEY	Sort keys of the table.
PROPERTIES	Properties of the table.
TABLE_ID	ID of the table.