Answers for "create primary key ms sql in existing column"

SQL
1

change primary key sql

ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)
Posted by: Guest on September-21-2020
0

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 "create primary key ms sql in existing column"

Code answers related to "SQL"

Browse Popular Code Answers by Language