Column Properties (OLE DB)

The DBPROPSET_COLUMN property set contains the following properties.

Property ID	Description
DBPROP_COL_AUTOINCREMENT	Type: VT_BOOL Typical R/W: R/W Notes: Specifies whether the values of the identity column are auto-incrementing. There can be only one auto-incrementing column per table. SQL Server Compact supports the auto-increment attribute on DBTYPE_I8 and DBTYPE_I4 columns.
DBPROP_COL_DEFAULT	Type: Any Typical R/W: R/W Notes: Specifies the default value for this column. This may be a constant, an expression, or the getdate function. Queries are not supported as default values. String literals must be enclosed with single quotation marks, for example, 'myString'.
DBPROP_COL_FIXEDLENGTH	Type: VT_BOOL Typical R/W: R/W
DBPROP_COL_INCREMENT	Type: VT_I4 Typical R/W: R/W Notes: Only used if auto-increment is VARIANT_TRUE, and can only be used on identity columns.
DBPROP_COL_ISLONG	Type: VT_BOOL Typical R/W: R/W
DBPROP_COL_NULLABLE	Type: VT_BOOL Typical R/W: R/W Notes: SQL Server Compact supports all types as nullable.
DBPROP_COL_SEED	Type: VT_I4 Typical R/W: R/W Notes: Only used if auto-increment is VARIANT_TRUE, and can only be used on identity columns.

Ytterligare resurser