ms sql priamry key code example

Example 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>)

Example 2: create id to primary using query

ALTER TABLE lead_offer_notes ADD PRIMARY KEY (id);