The DBPROPSET_COLUMN property set contains the following properties.
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.
|