Metadata System Tables

The metadata system tables provide information about the metadata of the database. The metadata system tables are 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.

Click on the table names below for more details about each metadata system table.

System table name Description
EXA_ALL_COLUMNS Contains information on all the table columns to which the current user has access.
EXA_ALL_COLUMN_SIZES Lists the compressed and raw sizes of all columns in all user tables in all schemas to which the current user has access
EXA_ALL_CONNECTIONS Lists all connections of the database.
EXA_ALL_CONSTRAINT_​COLUMNS Contains information about referenced table columns of all constraints to which the current user has access.
EXA_ALL_CONSTRAINTS Contains information about constraints of tables to which the current user has access.
EXA_ALL_DEPENDENCIES Lists all direct dependencies between schema objects to which the current user has access.
EXA_ALL_FUNCTIONS Describes all functions of the database to which the current user has access. All users have access.
EXA_ALL_INDICES Describes all indexes on tables to which the current user has access.
EXA_ALL_OBJ_PRIVS

Contains all object privileges granted to or by the current user or one of its roles. Additionally it contains object privileges for all objects owned by the current user or one of its roles.

EXA_ALL_OBJ_PRIVS_MADE

Lists all object privileges granted by the current user. Additionally it contains object privileges for all objects owned by the current user or one of its roles.

EXA_ALL_OBJ_PRIVS_RECD

Lists all object privileges granted to the user directly, through one of its roles, or through PUBLIC.

EXA_ALL_OBJECT_SIZES Contains the sizes of all of the database objects to which the current user has access.
EXA_ALL_OBJECTS Describes all of the database objects to which the current user has access.
EXA_ALL_ROLES A list of all roles known to the system.
EXA_ALL_SCHEMA_OBJECTS Lists all objects in the current schema to which the current user has access.
EXA_ALL_SCHEMAS Lists all the schemas to which the current user has access.
EXA_ALL_SCRIPTS Describes all scripts of the database to which the current user has access.
EXA_ALL_SESSIONS Contains restricted information on open sessions of any database user.
EXA_ALL_TABLES Describes all of the tables in the database to which the current user has access.
EXA_ALL_USERS Provides restricted information on all of the users known to the system.
EXA_ALL_VIEWS Lists all of the views accessible to the current user.
EXA_ALL_VIRTUAL_COLUMNS Lists all columns of virtual tables to which the current user has access. It contains the information which are specific to virtual columns.
EXA_ALL_VIRTUAL_​SCHEMA_PROPERTIES Contains information on the properties of all virtual schemas to which the current user has access.
EXA_ALL_VIRTUAL_SCHEMAS Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas.
EXA_ALL_VIRTUAL_TABLES Lists all virtual tables to which the current user has access. It contains the information which are specific to virtual tables.
EXA_CACHE_CONTENT This system table lists all contents of SSD cache of all nodes.
EXA_CLUSTERS This system table contains information about the clusters currently active.
EXA_CONSUMER_GROUPS Lists all the consumer groups known to the system.
EXA_DBA_COLUMN_SIZES Lists the compressed and raw sizes of all columns in all user tables in all schemas.
EXA_DBA_COLUMNS Contains information on all table columns.
EXA_DBA_CONNECTION_PRIVS

Lists all connections that were granted in the database.

EXA_DBA_CONNECTIONS Lists all connections of the database.
EXA_DBA_CONSTRAINT​_COLUMNS Contains information about referenced table columns of all constraints of the database.
EXA_DBA_CONSTRAINTS Contains information about all constraints of the database.
EXA_DBA_DEPENDENCIES Lists all the direct dependencies between schema objects.
EXA_DBA_DEPENDENCIES​_RECURSIVE Lists all the direct and indirect dependencies between schema objects (thus recursive).
EXA_DBA_FUNCTIONS Describes all function of the database.
EXA_DBA_IMPERSONATION​_PRIVS Lists the specific privileges who can impersonate whom.
EXA_DBA_INDICES Describes all indexes on tables.
EXA_DBA_OBJ_PRIVS Contains all of the object privileges granted for objects in the database.
EXA_DBA_OBJECT_SIZES Contains the sizes of all database objects. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained within.
EXA_DBA_OBJECTS Describes all of the database objects.
EXA_DBA_RESTRICTED​_OBJ_PRIVS Lists all connection objects to which certain, restricted scripts were granted access to.
EXA_DBA_ROLE_PRIVS List of all roles granted to a user or a role.
EXA_DBA_ROLES A list of all roles known to the system.
EXA_DBA_SCHEMA_OBJECTS Lists all objects in the current schema.
EXA_DBA_SCHEMAS Lists all schemas.
EXA_DBA_SCRIPTS Describes all scripts of the database.
EXA_DBA_SESSION_RESOURCES Shows all sessions and associated resources limits known to the system.
EXA_DBA_SESSIONS Contains complete information on open sessions of any database user.
EXA_DBA_SYS_PRIVS Shows the system privileges granted to all users and roles.
EXA_DBA_TABLES Describes all tables in the database.
EXA_DBA_USERS Provides complete information on all of the users known to the system.
EXA_DBA_VIEWS Lists all views in the database.
EXA_DBA_VIRTUAL_COLUMNS Lists all columns of virtual tables. It contains the information which are specific to virtual columns.
EXA_DBA_VIRTUAL​_SCHEMA_PROPERTIES Lists the properties of all virtual schemas in the database.
EXA_DBA_VIRTUAL_SCHEMAS Lists all virtual schemas and shows the properties which are specific to virtual schemas.
EXA_DBA_VIRTUAL_TABLES Lists all virtual tables and contains the information which are specific to virtual tables.
EXA_DB_SNAPSHOTS This system table contains information on all database snapshots.
EXA_LOADAVG Contains information on the current CPU load in each of the Exasol nodes.
EXA_METADATA Contains information that describes the properties of the database.
EXA_OBJECTSTORAGE_USAGE Shows details of the database usage of the cloud storage volumes.
EXA_PARAMETERS Provides the database parameters - both system-wide and session-based information is displayed.
EXA_ROLE_CONNECTION​_PRIVS Lists any connection that the current user possesses indirectly via other roles.
EXA_ROLE_OBJ_PRIVS Lists all object privileges that have been granted to roles of the user.
EXA_ROLE_RESTRICTED​_OBJ_PRIVS

Lists all connection objects that certain restricted scripts were granted access to through one of the roles of the current user.

EXA_ROLE_ROLE_PRIVS Lists any role that the current user possesses indirectly via other roles.
EXA_ROLE_SYS_PRIVS Lists any system privilege that the current user possesses through roles.
EXA_SCHEMA_OBJECTS Lists all objects that exist in the current schema.
EXA_SCHEMAS Lists all the schemas of the database.
EXA_SESSION_CONNECTIONS List of all connections the user can access.
EXA_SESSION_PRIVS Lists all of the system privileges the user currently disposes of.
EXA_SESSION_ROLES Lists all roles held by the current user.
EXA_SPATIAL_REF_SYS List of supported spatial reference systems.
EXA_SQL_KEYWORDS Contains all SQL keywords in Exasol.
EXA_SQL_TYPES Describes the SQL data types of Exasol.
EXA_STATISTICS_OBJECT_SIZES This system table contains the sizes of all statistical system tables aggregated by the type of the statistical info.
EXA_SYS_COLUMNS This system table contains information on all system table columns.
EXA_SYS_SCRIPTS This system table describes all system scripts of the database.
EXA_TIME_ZONES Lists all named timezones supported by the database.
EXA_USER_COLUMNS Contains information on the table columns to those tables owned by the current user.
EXA_USER_COLUMN_SIZES Lists the compressed and raw sizes of all columns in all user tables in all schemas owned by the current user.
EXA_USER_CONNECTION_PRIVS Lists all connections which were granted directly to the user.
EXA_USER_CONSTRAINT​_COLUMNS Contains information about referenced table columns of all constraints owned by the current user.
EXA_USER_CONSTRAINTS Contains information about constraints of tables owned by the current user.
EXA_USER_DEPENDENCIES Lists all direct dependencies between schema objects owned by the current user.
EXA_USER_FUNCTIONS Describes all functions in the database owned by the current user.
EXA_USER_IMPERSONATION​_PRIVS Lists the specific impersonation privileges granted to current user.
EXA_USER_INDICES Describes all indexes on tables owned by the current user.
EXA_USER_OBJ_PRIVS

Lists all object privileges granted directly to or by the current user.

EXA_USER_OBJ_PRIVS_MADE

Lists all object privileges granted by the current user.

EXA_USER_OBJ_PRIVS_RECD Lists all object privileges granted directly to the user.
EXA_USER_OBJECT_SIZES Contains the size of all database objects owned by the current user.
EXA_USER_OBJECTS Lists all of the objects owned by the current user.
EXA_USER_RESTRICTED​_OBJ_PRIVS Lists all connection objects to which certain, restricted scripts were granted access to, granted directly to the current user.
EXA_USER_ROLE_PRIVS Lists all of the roles directly granted to the current user (not via other roles).
EXA_USER_SCHEMA_OBJECTS Lists all objects in the current schema that are owned by the current user.
EXA_USER_SCHEMAS Lists all the schemas that are owned by the current user.
EXA_USER_SCRIPTS Describes all of the scripts in the database owned by the current user.
EXA_USER_SESSION_RESOURCES Shows all sessions that are owned by the current user and associated resource limits.
EXA_USER_SESSIONS Contains complete information on open sessions of the current user.
EXA_USER_SYS_PRIVS Lists all system privileges that have been directly granted to the user.
EXA_USER_TABLES Describes all of the tables in the database owned by the current user.
EXA_USER_USERS Provides detailed information about the user currently logged in.
EXA_USER_VIEWS Lists all views owned by the current user.
EXA_USER_VIRTUAL_COLUMNS Lists all columns of virtual tables owned by the current user.
EXA_USER_VIRTUAL​_SCHEMA_PROPERTIES Contains information on the properties of all virtual schemas belonging to the current user.
EXA_USER_VIRTUAL_SCHEMAS Lists all virtual schemas that are owned by the current user and shows the properties which are specific to virtual schemas.
EXA_USER_VIRTUAL_TABLES Lists all virtual tables owned by the current user.
EXA_VIRTUAL_SCHEMAS Lists all virtual schemas and shows the properties which are specific to virtual schemas.
EXA_VOLUME_USAGE Shows details of the database usage of the storage volumes.