Share via

Column Properties (OLE DB)

  • Article

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.