SCHEMATA Rowset

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