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 |
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. |