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 |
Difference between windows application and web application? Which is the best for updation purpose?
How can we Validate a Controls in ASP.NET page using JavaScript?
How to implement form based authentication in asp.net application?
What is runat?
Which object encapsulates state or data of a user?
Which two new properties are added in asp.net 4.0 page class?
What are generics? why it is used? architecture of ASP.NET?
7 Answers Path Infotech, Satyam, TCS,
how to transfer the file from client to server using asp.net
0 Answers Sans Pareil IT Services,
What are the different types of sessions in asp.net? Name them?
What's the use of formatters in .net?
What are the advantages of passport authentication?
Can we use multiple forms in single asp.net application?