MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets


 

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