SCHEMATA Rowset

OLE DB Programmer's Reference

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.

1998-2001 Microsoft Corporation. All rights reserved.