Interested to Buy Any Domain ? << Click Here >> for more details...
can u create two Primary key for a table?
--Sivaa
- 10 Answers
- 12701 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 |
what is PostBack Property exactly ? when It Returns True? when it Returns False?
Where is the view state data stored in asp net?
What is meant by ispostback in asp net?
Tell something about state management in asp.net?
What is caching? What are the different types of caching?
What is the size of Get method and how much data it can store?
What are the layouts of ASP.NET Pages?
In try catch blocks one is normal catch block and another is sqlcatchexception block
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
Have u used webcontrols?Tell me something about these?
What is advantage of viewstate and what are benefits ?
What are the event handlers that can be included in the Global.asax file?
-
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)
