Creating PK on all existing tables where PK does not exists

Hi Experts,

I have been asked to create PK on many tables using a query on all tables where we do not have clustered indexes. Some of the tables contains PK but non-clustered. If in a table there are no PK, then how to decide on which column PK can be created? can we do it with the help of a query without data loss and without human intervention?

Thanks in advance.

Regards,

Naveen JV

---

Naveen J V