Creating composite primary key in SQL Server

Question

How to add composite primary keys in SQL Server 2008?

I have a table as follows.

testRequest (wardNo nchar(5)             , BHTNo nchar(5)             , testID nchar(5)             , reqDateTime datetime); 

I need wardNo, BHTNo and testID to be a composite primary key.

How can I do this in SQL Server Management Studio?

Answer 1

If you use management studio, simply select the wardNo, BHTNo, testID columns and click on the key mark in the toolbar.

Command for this is,

ALTER TABLE dbo.testRequest ADD CONSTRAINT PK_TestRequest  PRIMARY KEY (wardNo, BHTNo, TestID)