can u create two Primary key for a table? --Sivaa

Categories >> Software >> Microsoft Related >> ASP.NET
Suggest New Category

can u create two Primary key for a table?
--Sivaa

Question Posted / sivaprakasam

10 Answers
13367 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can u create two Primary key for a table? --Sivaa..

Answer / monalisa behera

No, we cannot create more than one Primary key for a table.
Composite Primary key as mentioned in the answer by
Purushotham consists of more than one columns together
making a Primary key. In such a case the columns may be
more than one but the Primary key is one.

Is This Answer Correct ?

15 Yes

0 No

can u create two Primary key for a table? --Sivaa..

Answer / purushotham

S we can create its called composite key

ALTER TABLE TableName
ADD CONSTRAINT CONSTRAINT _Name
PRIMARY KEY (attribute1,attribute2)

Is This Answer Correct ?

12 Yes

3 No

can u create two Primary key for a table? --Sivaa..

Answer / sivaprakasam

Is This Answer Correct ?

5 Yes

4 No

can u create two Primary key for a table? --Sivaa..

Answer / santosh

No, we can't create two primary keys for a table. A table
contains only one primary key.
A table can have one or more unique keys.

Is This Answer Correct ?

3 Yes

2 No

can u create two Primary key for a table? --Sivaa..

Answer / purushotham tella

no, we can't create more than 1 primary key on a
table .Monalisa Behera is correct we can add more than 1
columns together to make primary key.Srry misleading in
earlier post

Is This Answer Correct ?

2 Yes

1 No

can u create two Primary key for a table? --Sivaa..

Answer / sudheekar reddy

No,we can't create two primary key's in 1 table.
Because in the above monalisa has mentioned the clearly
that to make primary key we can have a single column or
combination of columns.

Is This Answer Correct ?

0 Yes

0 No

can u create two Primary key for a table? --Sivaa..

Answer / sanjay maurya

no, we can't create two pimary key in one table
A table can have one or more unique keys.

Is This Answer Correct ?

0 Yes

0 No

can u create two Primary key for a table? --Sivaa..

Answer / raghunath

no we cant create 2 primary keys

Is This Answer Correct ?

1 Yes

2 No

can u create two Primary key for a table? --Sivaa..

Answer / rambhopal reddy

no,we can't create two primary key's in 1 table.

Is This Answer Correct ?

2 Yes

5 No

can u create two Primary key for a table? --Sivaa..

Answer / saiish bhat

It depends.
but we can use 2 primary key per table.

Is This Answer Correct ?

1 Yes

7 No

Post New Answer

More ASP.NET Interview Questions

Why is an object pool required?

0 Answers

Briefly describe the role of global.asax?

0 Answers

Can a master page inherit another master page?

13 Answers Emphasis, IBM, NIIT, Sebiz Square,

Explain the difference between debug.write and trace.write? When should each be used?

0 Answers

benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks

0 Answers

Explain the difference between Repeater and Data list control in ASP.NET?

0 Answers

About dataset and data mining ?

1 Answers Cognizant,

Explain difference between friend and protected friend?

0 Answers

What type of code (server or client) is found in a Code- Behind class?

2 Answers

What r new things introduced in ASP.NET 2.0 in comparision to ASP.NET 1.1

1 Answers

Difference between asp and asp.net?

4 Answers Accenture,

define silverlight and advantages ?

3 Answers QA,

For more ASP.NET Interview Questions Click Here