Can a table have two primary keys?
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 the uses of merge?
What is join view in sql?
What are instead of triggers?
What are the usages of sql?
What are the commands used in sql?
What is structural independence and why is it important?
Which join is like an inner join?
What is secondary key?
What is the benefit of foreign key?
What is dynamic query?
What is the difference between in and between in sql?
What is relationship? How many types of relationship are there?
Which are the different character-manipulation functions in sql?
Enlist the characteristics of pl/sql?
What is sap sql anywhere?