Answers for "adding primary key to a table in sql in create table"

add primary key to existing table sql

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

Posted by: Guest on February-08-2021

sql server add primary key to existing table with data

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

Posted by: Guest on July-22-2020

Code answers related to "adding primary key to a table in sql in create table"