EXA_ALL_TABLES
This system table describes all of the tables in the database to which the current user has access. All users 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 |