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 Edition 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 2005 Compact Edition 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.