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_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.