SCHEMATA

Provides information about schemas in the database.

Column Name Data Type Description
SCHEMA_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the specific schema.

SCHEMA_NAME

VARCHAR

Schema name for which information is listed.

SCHEMA_OWNER_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the owner who created the schema.

SCHEMA_OWNER

VARCHAR

Name of the owner who created the schema.

SYSTEM_SCHEMA_CREATOR

VARCHAR

Creator information for system schema or NULL for non-system schema

CREATE_TIME

TIMESTAMPTZ

Time when the schema was created.

IS_SYSTEM_SCHEMA

BOOLEAN

Indicates whether the schema was created for system use, where t is true and f is false.

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.