Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 96351 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answer Posted / subbarayulu
No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are sql queries used for?
Is it possible to create startup or shutdown trigger for on-schema?
What will you get by the cursor attribute sql%notfound?
what is bdb (berkeleydb)? : Sql dba
What has stored procedures in sql?
What is the difference between between and in condition operators?
What is bulk compiling in pl/sql.?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are the different types of constraints?
What does an inner join do?
What is the main reason behind using an index?
how can we optimize or increase the speed of a mysql select query? : Sql dba
How to select unique records from a table?
Which join is default?
What is the difference between having and a where in sql?
