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. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, `n1.s` refers to schema `s` in namespace `n1`.
`SCHEMA_NAMESPACE_NAME`	VARCHAR	For Eon Mode databases, name of the namespace that contains the schema.
`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.