can u create two Primary key for a table?
--Sivaa
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Answer / rambhopal reddy
no,we can't create two primary key's in 1 table.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / saiish bhat
It depends.
but we can use 2 primary key per table.
| Is This Answer Correct ? | 1 Yes | 7 No |
How do I debug an asp.net application that was not written with visual studio.net and that does not use code-behind?
what is diference between the .net1.0 & .net2.0 ?
What is the Web.config file used for? a) To store the global information and variable definition for the application. b) Configures the time that the server-side codebehind module is called c) To Configure the Web Server. d) To Configure the Web browser.
8 Answers HCL, IBM, Syntax Softtech, Vypin, WideVision Technologies,
what is silver light when will we use silver light,
Explain the advantages of passport authentication.
What are Authentication and Authorization?
Differences between VB.Net and C#, related to OOPS concepts
How we implement the multiple paypal value with gridview in my website and how we make a payment through Credit Card.
What is the significance of proxy user?
What are the security types in ASP/ASP.NET? Different Authentication modes?
How do you do Client-side validation in .Net?
How to remove cache object in asp.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)