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

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

Question Posted / sivaprakasam

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

No

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

Name the control which can be used to reserve the space on web page for storing localized data.

3 Answers   IBM,

What is the server of asp.net?

0 Answers  

what are configuration files?

0 Answers  

How to write unmanaged code and how to identify whether the code is managed /unmanaged?

4 Answers   Accenture,

What is autopost?

0 Answers  




What are main return types supported in Web API?

0 Answers  

How we can set Different levels of Authentication in .Net? What are the difference between Windows Authenticatin, Passport Authentication and Form Authentication?

1 Answers  

What tags do you need to add within the asp:datagrid tags to bind columns manually?

5 Answers   Siebel Systems,

In asp.net, if a webpage seems too slow to load completely in th ebrowser. In this case what are the checkings or actions you will take to rectify the slowness or which are the factors related to this issue? How we can trace it?

3 Answers  

how can i am search the data from database? just like google

2 Answers  

Types of caching ?

3 Answers   TCS,

What is difference between session and cookies?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories