• Jim McLeod (7/15/2010)

    Here's another fun question - what's the difference between a primary key and any other unique key, regardless of whether it's clustered or not?

    PK allows NO nulls in key columns, where a Unique constraint will allow records that contain a null in the key columns (still must be unique, however).