Interested to Buy Any Domain ? << Click Here >> for more details...
can u create two Primary key for a table?
--Sivaa
- 10 Answers
- 13125 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 new debug tools in asp.net ?
What is app_code folder in asp net?
Can we use html in asp.net?
how we use web services
Clearly Explain the ispostback
Describe in brief .net framework and its components.
Define transparent caching with aop?
How many Garbage Collectors are there for one Application or one Page
What are typed datasets?
hi guys do u know how to go one page to one page to another page plz tell me any of u know
how can create login from create and written conde in asp.net
How do you perform validations?
-
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)
