VIEWS Rowset
GUID: DBSCHEMA_VIEWS
Number of restriction columns: 3
Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
Default sort order: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
Description: The VIEWS rowset identifies the views defined in the catalog that are accessible to a given user.
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. |