SQL - Can a primary key contain more than one columns?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 8 of 171

Can a primary key contain more than one columns?

Yes

Total Answers and Comments: 17

Last Update: September 17, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: nitin

hi everyone!
yes PK can have more than one column! it is used as compostie PK!
we can have this composite PK with an table!

Above answer was rated as good by the following members:
satyam_Ora

Sorting Options

Page 1 of 2

« First

Last »

August 14, 2005 07:46:52

deepak

RE: Can a primary key contain more than one columns?

I am not satisfied with that answer.can anybody eleborate it.plzzzzz

Is this answer useful? Yes | No

August 23, 2005 08:34:49

mahendra

RE: Can a primary key contain more than one columns?

Composite primary keys are based on more than one column

Is this answer useful? Yes | No

August 26, 2005 13:27:21

Allam Ravi

RE: Can a primary key contain more than one columns?

NO A table can have Only One primary key.
but a table can have any number of composite primary key's

Is this answer useful? Yes | No

November 07, 2005 01:44:44

maheshwari

RE: Can a primary key contain more than one columns?

Is this answer useful? Yes | No

November 08, 2005 14:43:12

PrasadVB

Member Since: November 2005 Contribution: 1

RE: Can a primary key contain more than one columns?

Yes. A primary key can have more than one column. If it does .. it is called a Composite Primary Key. But a table cannot have more than one promary key. Hope this answers your question.

Is this answer useful? Yes | No

August 02, 2006 07:41:16

gannesunil

Member Since: August 2006 Contribution: 6

RE: Can a primary key contain more than one columns?

table contains only one primary key

Is this answer useful? Yes | No

August 25, 2006 05:02:01

nitin

RE: Can a primary key contain more than one columns?

hi everyone!
yes PK can have more than one column! it is used as compostie PK!
we can have this composite PK with an table!

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 13, 2007 13:28:00

Rohan Deshpande

RE: Can a primary key contain more than one columns?

No. primary can't be imposed on more than column separately.if it shard then it is called as composite primary key.

Is this answer useful? Yes | No

April 09, 2007 07:35:18

shikha

RE: Can a primary key contain more than one columns?

Yes. A primary key can have more than one column. If it has have more than one column it is called a Composite Primary Key.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 03, 2007 08:06:57

#10

Tarun

RE: Can a primary key contain more than one columns?

Yes a primary key can contain more than one column. such a primary key is called a composite primary key.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank