| OLE DB Programmer's Reference |  |
| 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. |