The Identity property can't be set on column '<0s>' because it has a default value.

Message Text

The Identity property can't be set on column '<0s>' because it has a default value.

Explanation

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

See Also
ALTER TABLE How to create a database (Enterprise Manager)
CREATE DEFAULT How to set column properties using a database diagram (Enterprise Manager)
CREATE TABLE Modifying Column Properties
Creating and Modifying DEFAULT Definitions Setting Properties in a Database Diagram
Creating and Modifying Identifier Columns sp_bindefault
DEFAULT Definitions  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.