Share via


DBPROP_UNIQUEROWS

Property group: Rowset

Property set: DBPROPSET_ROWSET

Type: VT_BOOL

Typical R/W: R/W

Description: Unique Rows

Value

Meaning

VARIANT_TRUE

Each row is uniquely identified by its column values.

VARIANT_FALSE

Rows in the rowset may or may not be uniquely identified by their column values.

If this property is set to VARIANT_TRUE when opening the rowset, the provider adds additional columns, if necessary, to ensure that each row is uniquely identified by its values. These additional columns appear at the end of the rowset; have a DBID of type DBKIND_GUID_PROPID, DBKIND_PGUID_PROPID, DBKIND_GUID_NAME, or DBKIND_PGUID_NAME; and the guid (or pguid) element is (or points to) DBCOL_SPECIALCOL. These columns typically are not displayed to the user but are used by components such as update services to uniquely identify a row.

The provider optionally may duplicate existing columns in the rowset to ensure that key columns are included.

If this property is set to VARIANT_TRUE and the provider supports the optional IColumnsRowset metadata column DBCOLUMN_KEYCOLUMN, the set of columns that uniquely identify the row have a value of VARIANT_TRUE in the DBCOLUMN_KEYCOLUMN column returned by IColumnsRowset. This may be a subset of the columns in the row, or all of the columns if the provider cannot determine a proper subset that uniquely identifies the row.

See Also

Reference

Properties (Alphabetical)