SCHEMAS

The SCHEMAS view contains the name and system identifier for each schema. The table below lists the columns that are associated with the SCHEMAS view:
Name
Type
Description
SCHEMA_NAME
VARCHAR(256)
Specifies the schema name.
CATALOG_NAME
VARCHAR(256)
Specifies the name of the catalog. If not applicable, the value is NULL.
USER_NAME
VARCHAR(256)
Specifies the user name of the schema owner.
Last updated: March 6, 2018