VIEWS Rowset

The VIEWS rowset identifies the viewed tables 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, that is:
  • VARIANT_TRUE, which indicates local update checking only.

  • VARIANT_FALSE, which indicates cascaded update checking.
IS_UPDATABLE DBTYPE_BOOL Specifies values as either of:
  • VARIANT_TRUE, which indicates that the view is updatable.

  • VARIANT_FALSE, which indicates that the view is not updatable.
DESCRIPTION DBTYPE_WSTR Human-readable description of the view.

Default Sort Order: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME.