This article describes the catalog system tables in Exasol.
EXA_SYSCAT
The EXA_SYSCAT system table lists all existing system tables. The EXA_SYSCAT table is placed
in the system schema SYS.
The system schemas SYS and EXA_STATISTICS are automatically integrated into the namespace. This means that the tables in the system schemas can be accessed without specifying the schema as long as the same table name is not in use in the current schema.
The EXA_SYSCAT table is available to all users.
| Column | Meaning |
|---|---|
SCHEMA_NAME
|
Name of the system schema |
OBJECT_NAME
|
Name of the system table |
OBJECT_TYPE
|
Type of object: TABLE or VIEW |
OBJECT_COMMENT
|
Comment on the object |
