Vertica Analytics Platform Version 10.1.x Documentation

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.