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?

possible duplicate of how do I make a composite key with SQL Server Management Studio? — Brian Hooper
– Brian Hooper, Commented Apr 29, 2015 at 14:35

User1000547 · Accepted Answer · 2015-07-10 15:35:41Z

61

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

enter image description here

Command for this is,

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

edited Jul 10, 2015 at 15:35

User1000547

4,3219 gold badges44 silver badges68 bronze badges

answered Oct 1, 2012 at 6:46

Madusanka

3,0305 gold badges32 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

usefulBee Over a year ago

What is the name of the toolbar?

Simple Sandman Over a year ago

@usefulBee Table Designer

Austine Gwa Over a year ago

Works perfectly. Also a point to note the fields must not be nullable

marc_s · Accepted Answer · 2012-09-26 04:59:34Z

42

How about this:

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

answered Sep 26, 2012 at 4:59

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

1 Comment

Sakthivel Over a year ago

This is good. Practicing query in sql is always challenging !

Adriaan Stander · Accepted Answer · 2012-09-26 04:59:34Z

32

How about something like

CREATE TABLE testRequest (
        wardNo nchar(5),
        BHTNo nchar(5),
        testID nchar(5),
        reqDateTime datetime,
        PRIMARY KEY (wardNo, BHTNo, testID)
);

Have a look at this example

SQL Fiddle DEMO

answered Sep 26, 2012 at 4:59

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Comments

silambarasan vediappan · Accepted Answer · 2016-05-10 09:48:23Z

5

it simple, select columns want to insert primary key and click on Key icon on header and save table

happy coding..,

answered May 10, 2016 at 9:48

silambarasan vediappan

1521 silver badge12 bronze badges

Collectives™ on Stack Overflow

Creating composite primary key in SQL Server

4 Answers 4

3 Comments

1 Comment

SQL Fiddle DEMO

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related