Identity

Description

Whether the database is to supply the value of the column in a newly inserted row. If so, the column is not updatable; the column is excluded from the INSERT statement.

Not all DBMSs support the identity property. For more information see the documentation for your DBMS.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.Identity { = ' value ' }"

Parameter

Description

columnname

A string containing the name of the column for which you want to get or set the identity property.

value

A string indicating whether a column’s value in a newly inserted row is supplied by the DBMS:

  • Yes – The DBMS will supply the value of the column in a newly inserted row; the column is not updatable.

  • No – The column is updatable.

Examples

Example 1

[Visual Basic]
dw1.Modify("empid.Identity='yes'")