SYSTEM_TABLES
Returns a list of all system table names.
Column Name | Data Type | Description |
---|---|---|
TABLE_SCHEMA_ID |
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the schema. |
TABLE_SCHEMA |
VARCHAR |
The schema name in which the system table resides. Values are: |
TABLE_ID |
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which 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 |
Indicates if the table is accessible only by a user with superuser privileges. Values are: t - table is accessible by superuser only f - table is accessible by other users |
IS_MONITORABLE |
BOOLEAN |
Indicates if the table is accessible by a user with the SYSMONITOR role enabled. Values are: t - table is accessible by SYSMONITOR role f - table is not accessible by SYSMONITOR role See SYSMONITOR Role. |
IS_ACCESSIBLE_DURING_LOCKDOWN |
BOOLEAN | Indicates if the table is restricted using the RestrictSystemTables parameter. See System Table Restriction. |