How to set Primary Key constraints on multiple columns in a table in SQL Server?

Question

Ashutosh Kumar Verma · Answer

Set multiple columns as Primary Key in a table :
Generally we have to set a primary key on single column in a table, but if we have need to create more than one columns as primary key then we can use the following SQL Statement,
1- when table is created 
CREATE TABLE tblTestDemo(
ID INT NOT NULL,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Address VARCHAR(100),
PRIMARY KEY(ID, FirstName)
);
2- If there is no column is set as primary key in created table and we have need to set two or more columns set as primary key then use the following SQL Statement.
and ALTER TABLE tblTestDemo
ADD PRIMARY KEY(ID, FirstName);

forum

How to set Primary Key constraints on multiple columns in a table in SQL Server?

Steilla Mitchel

Can you answer this question?

1 Answers

Liked By