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.