SQL Server – Primary Key and a Unique Key

[skhanal]

You can have only one primary key in a table but can have multiple unique keys, which by the way violates 3rd normal form.