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