Learn about all the system tables in Exasol.
An Exasol catabase contains a number of 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 of the 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.
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.
