SCHEMATA

Provides information about schemas in the database.

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_NAMESPACE_NAME VARCHAR For Eon Mode databases, name of the namespace to which the schema belongs.
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

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.