Catalog System Tables


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