You can also create multiple unique indexes on the same table, but you can have only one primary key.
A unique index can also be filtered, while a PK cannot.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP