The Default Value property can't be set on column <Columnname> because it is an identity column. (Visual Database Tools)
TOC
Collapse the table of content
Expand the table of content

The Default Value property can't be set on column <Columnname> because it is an identity column. (Visual Database Tools)

Identity columns contain system-generated sequential values that uniquely identify each row within the table. Therefore, identity columns cannot have default values.

For more information, see How to: Modify Column Identity Properties (Visual Database Tools) and How to: Specify Default Values for Columns (Visual Database Tools).

Community Additions

ADD
Show:
© 2016 Microsoft