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

What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

8 Answers   Siebel Systems,

What is the name of the process the browser uses to find the address of a web server? a) DMZ b) DNS c) Active Directory d) Database lookup

1 Answers   Syntax Softtech,

Is overloading possible in web services?

2 Answers   Microsoft,

How do you register the .Net Component or Assembly?

2 Answers   Accenture,

What is the use of web.config? Difference between machine.config and Web.config?

5 Answers  




When you are running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?

0 Answers   BirlaSoft,

How do you get records number from 5 to 15 from a dataset of 100 records?

3 Answers   Syntax Softtech,

What is the best way to search any exact information on google?

3 Answers   Intellevate,

Can we make activex dll also ti execute in some process as that of client ? How can we do?

0 Answers   DELL, Zerone,

Can we use http handlers to upload a file in asp.net?

2 Answers  

About Usage of server variables ?

2 Answers   Cognizant, CTS,

Explain the procedure to handle the process request using mhpm events fired? : asp.net mvc

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories