MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets
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