This system table describes all tables in the database. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
TABLE_SCHEMA Name of the schema of the table
TABLE_NAME Name of the table
TABLE_OWNER Owner of the table
TABLE_OBJECT_ID ID of the table
TABLE_IS_VIRTUAL States whether this is a virtual table
TABLE_HAS_DISTRIBUTION_KEY States whether the table is explicitly distributed
TABLE_HAS_PARTITION_KEY States whether the table is partitioned
TABLE_ROW_COUNT Number of rows in the table
DELETE_PERCENTAGE Fraction of the rows which are just marked as deleted, but not yet physically deleted (in percent)
TABLE_COMMENT Comment on the table