SCHEMATA Rowset

GUID: DBSCHEMA_SCHEMATA

Number of restriction columns: 3

Restriction columns: CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER

Default sort order: CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER

Description: The SCHEMATA rowset identifies the schemas that are owned by a given user.

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.