Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
GUID: DBSCHEMA_VIEW_COLUMN_USAGE
Number of restriction columns: 3
Restriction columns: VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME
Default sort order: VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_GUID, COLUMN_PROPID
Description: The VIEW_COLUMN_USAGE rowset identifies the columns on which viewed tables, defined in the catalog and owned by a given user, are dependent.
Column name |
Type indicator |
Description |
|---|---|---|
VIEW_CATALOG |
DBTYPE_WSTR |
Catalog name. NULL if the provider does not support catalogs. |
VIEW_SCHEMA |
DBTYPE_WSTR |
Unqualified schema name. NULL if the provider does not support schemas. |
VIEW_NAME |
DBTYPE_WSTR |
View name. |
TABLE_CATALOG |
DBTYPE_WSTR |
Catalog name in which the table is defined. NULL if the provider does not support catalogs. |
TABLE_SCHEMA |
DBTYPE_WSTR |
Unqualified schema name in which the table is defined. NULL if the provider does not support schemas. |
TABLE_NAME |
DBTYPE_WSTR |
Table name. |
COLUMN_NAME |
DBTYPE_WSTR |
Column name. This column, together with the COLUMN_GUID and COLUMN_PROPID columns, forms the column ID. One or more of these columns will be NULL, depending on which elements of the DBID structure the provider uses. |
COLUMN_GUID |
DBTYPE_GUID |
Column GUID. |
COLUMN_PROPID |
DBTYPE_UI4 |
Column property ID. |