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_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_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_PARAMETERS | Provides the database parameters - both system-wide and session-based information is displayed. |
EXA_PRIORITY_GROUPS | Lists all the priority groups known to the system. |
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_SNAPSHOT_BACKUP | This system table contains information on all database snapshots. |
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_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_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. |