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 |