KEY_COLUMN_USAGE Rowset
GUID: DBSCHEMA_KEY_COLUMN_USAGE
Number of restriction columns: 7
Restriction columns: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
Default sort order: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION
Description: The KEY_COLUMN_USAGE rowset identifies the columns defined in the catalog that are constrained as keys by a given user.
Column name |
Type indicator |
Description |
|---|---|---|
CONSTRAINT_CATALOG |
DBTYPE_WSTR |
Catalog name. NULL if the provider does not support catalogs. |
CONSTRAINT_SCHEMA |
DBTYPE_WSTR |
Unqualified schema name. NULL if the provider does not support schemas. |
CONSTRAINT_NAME |
DBTYPE_WSTR |
Constraint name. |
TABLE_CATALOG |
DBTYPE_WSTR |
Catalog name in which the table containing the key column is defined. NULL if the provider does not support catalogs. |
TABLE_SCHEMA |
DBTYPE_WSTR |
Unqualified schema name in which the table containing the key column is defined. NULL if the provider does not support schemas. |
TABLE_NAME |
DBTYPE_WSTR |
Table name containing the key column. |
COLUMN_NAME |
DBTYPE_WSTR |
Name of the column participating in the unique, primary, or foreign key. 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. |
ORDINAL_POSITION |
DBTYPE_UI4 |
Ordinal position of the column in the constraint being described. If the constraint being described is a key of cardinality one, the value of ORDINAL_POSITION is always one. |