alter column to primary key in sql server 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: primary key in sql

PRIMARY KEY
   -- unique identifier for the entire row of record in a table
   --  can not be null and must be unique

Tags:

Sql Example

Related