Answers for "add primary key in table sql"

add primary key to existing table sql

alter table Persion add primary key (persionId,Pname,PMID)

sql server add primary key to existing table with data

ALTER TABLE Production.TransactionHistoryArchive
   ADD CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (TransactionID);