All columns that are part of a tableÆs a primary key must contain aggregate unique values other than NULL. To add the column to a primary key, first clear the Allow Nulls check box on the Column Property dialog box.
For more information, see About Database Designer Considerations for SQL Server Databases.