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 |
If you are using two select queries and retrieving data. how do you access second query's result set using data reader?
1 Answers Cap Gemini, Keane India Ltd, MindSquare,
What are the Types of objects in ASP
How many types of controls are there in asp.net?
Tell me how asp.net mvc differs from asp.net web forms? : asp.net mvc
What are server-side comments in ASP.NET?
how can i insert array values and retreive in asp.net
What is the difference between a page theme and a global theme?
What is the relationship between IIS and ASP.NET in the generation of dynamic Web sites?
How many web.config files in each solution
Can any body provide me the sample web application in asp.net
Will the asp.net validators run in server side or client side? How do you do client-side validation in .net?
Where does the Web page belong in the .NET Framework class hierarchy?
1 Answers Perot Systems, Visual Soft,