The SCHEMATA rowset identifies the schemas that are owned by a given user.
The SCHEMATA rowset contains the following columns.
Column name | Type indicator | Description |
CATALOG_NAME | DBTYPE_WSTR | Catalog name. NULL if the provider does not support catalogs. |
SCHEMA_NAME | DBTYPE_WSTR | Unqualified schema name. |
SCHEMA_OWNER | DBTYPE_WSTR | User that owns the schemas. |
DEFAULT_CHARACTER_ SET_CATALOG |
DBTYPE_WSTR | Catalog name of the default character set for columns and domains in the schemas. NULL if the provider does not support catalogs or different character sets. |
DEFAULT_CHARACTER_ SET_SCHEMA |
DBTYPE_WSTR | Unqualified schema name of the default character set for columns and domains in the schemas. NULL if the provider does not support different character sets. |
DEFAULT_CHARACTER_ SET_NAME |
DBTYPE_WSTR | Default character set name. NULL if the provider does not support different character sets. |
Default Sort Order: CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER