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.

Show: