Metadata System Tables

The following table provides you with a list of all the metadata system tables in Exasol. Click the table name to view its details.

System Table Name Description
EXA_ALL_COLUMNS Contains information on all the table columns 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 indices on tables to which the current user has access.
EXA_ALL_OBJ_PRIVS Contains all of the object privileges granted for objects in the database to which the current user has access.
EXA_ALL_OBJ_PRIVS_MADE Lists all object privileges that are self-assigned by the user or those on objects that belong to the user.
EXA_ALL_OBJ_PRIVS_RECD Lists all object privileges granted to the user directly 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_CONSUMER_GROUPS Lists all the consumer groups known to the system.
EXA_DBA_COLUMN_SIZES Lists all columns in all (non-system-)tables in all schemas with their memory and raw sizes.
EXA_DBA_COLUMNS Contains information on all table columns.
EXA_DBA_CONNECTION_PRIVS Lists all connections which were granted to the user or one of their roles.
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 indices 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_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 to which certain, restricted scripts were granted access to, either granted directly to the current user or indirectly via other roles.
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_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_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 indices on tables owned by the current user.
EXA_USER_OBJ_PRIVS Contains all of the object privileges granted for objects in the database to which the current user has access (except via the PUBLIC role).
EXA_USER_OBJ_PRIVS_MADE Lists all of the object privileges related to objects owned 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.