System Tables

Exasol provides you with various system tables that describe the metadata of the database and the current status of the system. These system tables are located in SYS and EXA_STATISTICS schemas and are integrated automatically into the current namespace. You can access the system tables through the respective schema-qualified name, SYS.<table_name> (for example, SELECT * FROM SYS.DUAL). If an object with the same name does not exist in the current schema, then you can query it without stating the schema name, SYS.

Some system tables are critical to system security. You can access these tables only with SELECT ANY DICTIONARY system privilege (users with the DBA role have this privilege by default). It includes all system tables with the EXA_DBA_ prefix.

Some system tables are accessible to everyone. However, the content of these tables depends on the current user. For example, in EXA_ALL_OBJECTS, only the database objects the current user has access to are displayed.

The following sections describe Exasol's system tables and their access rules: