MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets
The VIEWS rowset identifies the views defined in the catalog that are accessible to a given user.
The VIEWS rowset contains the following columns.
| Column name | Type indicator | Description |
| TABLE_CATALOG | DBTYPE_WSTR | Catalog name. NULL if the provider does not support catalogs. |
| TABLE_SCHEMA | DBTYPE_WSTR | Unqualified schema name. NULL if the provider does not support schemas. |
| TABLE_NAME | DBTYPE_WSTR | View name. |
| VIEW_DEFINITION | DBTYPE_WSTR | View definition. This is a query expression. |
| CHECK_OPTION | DBTYPE_BOOL | Check option. One of the following:
VARIANT_TRUE—Local update checking only. VARIANT_FALSE—Cascaded update checking (same as no CHECK OPTION specified on view definition). |
| IS_UPDATABLE | DBTYPE_BOOL | VARIANT_TRUE—The view is updatable.
VARIANT_FALSE—The view is not updatable. |
| DESCRIPTION | DBTYPE_WSTR | Human-readable description of the view. |
| DATE_CREATED | DBTYPE_DATE | Date when the view was created or NULL if the provider does not have this information.
1.x providers do not return this column. |
| DATE_MODIFIED | DBTYPE_DATE | Date when the view definition was last modified or NULL if the provider does not have this information.
1.x providers do not return this column. |
Default Sort Order: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME