The Allow Nulls property can't be set on a column that is part of the primary key.

Message Text

The Allow Nulls property can't be set on a column that is part of the primary key.

Explanation

All columns that are part of a table’s a primary key must contain aggregate unique values other than NULL.

Action

To add the column to a primary key, first clear the Allow nulls check box in the Column Property dialog box.

See Also

Modifying Column Properties

  


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