primary key non clustered index

Question

I have a table with columns ID, Name, City, State, SSN, Phone. I have created a clustered index on ID column. I created non-clustered index on SSN column. Now, can I create primary key on the SSN column?

Answer 1

Hi ChaitanyaKiran-2787,

Yes. But please note that A table can contain only one PRIMARY KEY constraint. Any relationships to the existing primary key must be deleted before the new primary key can be created.
Please check https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-primary-keys?view=sql-server-ver15 for more details.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Yes, primary key doesn't have to be clustered, it just has to be unique.