The Identity property can't be set on column '<0s>' because it allows null values.

Message Text

The Identity property can't be set on column '<0s>' because it allows null values.

Explanation

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

See Also
Creating and Modifying Identifier Columns Key Object
How to set column properties using a database diagram (Enterprise Manager) Modifying Column Properties
  Setting Properties in a Database Diagram

 

  


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