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
Does inner join remove duplicates?
how to extract a unit value from a date and time? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
What is a primary key sql?
How do you modify a trigger?
What is the difference between truncate and drop statements?
tell me about various levels of constraint. : Sql dba
What is package in pl sql?
What is sqlca in db2?
How to create a menu in sqlplus or pl/sql?
How to display the records between two range in Oracle SQL Plus?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is full join?
What is difference sql and mysql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?