SYSTEM_TABLES
Returns a list of all system table names.
Column Name | Data Type | Description |
---|---|---|
TABLE_SCHEMA_ID |
INTEGER |
Catalog-assigned integer value that uniquely identifies the schema. |
TABLE_SCHEMA |
VARCHAR |
The schema name in which the system table resides, one of the following: |
TABLE_ID |
INTEGER |
Catalog-assigned integer value that uniquely identifies the table. |
TABLE_NAME |
VARCHAR |
The name of the system table. |
TABLE_DESCRIPTION |
VARCHAR |
A description of the system table's purpose. |
IS_SUPERUSER_ONLY |
BOOLEAN |
Specifies whether the table is accessible only by superusers. |
IS_MONITORABLE |
BOOLEAN |
Specifies whether the table is accessible by a user with the SYSMONITOR role enabled. |
IS_ACCESSIBLE_DURING_LOCKDOWN |
BOOLEAN |
Specifies whether non-superuser access to this system table is restricted after RESTRICT_SYSTEM_TABLES_ACCESS is called. By default, Vertica respects this setting and uses it to restrict system table access. To enable non-superuser access to all system tables, you must explicitly call RESTRICT_SYSTEM_TABLES_ACCESS. In general, this field is set to f (false) for system tables that contain information that is typically needed by most users, such as TYPES. Conversely, this field is set to t (true) for tables with data that should be restricted, such as database settings and user-specific information. |