Can a table have two primary keys?
Answer Posted / uhaish
Yes and it can and the number of primary keys in a single
table is not limited and can be 3,4, unlimited .The concept
is imagine 2 primary keys cols in a table as one primary
key col .
which means if you have two cols A and B both are primary
key by defination then..
AB
00
01
02
12
21
21
22
,see individually a primary key col is not anymore unique
but as hole its unique no other row in a table can have the
same combination of these two primary keys i.e '02' cannot
be repeated .
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what are enums used for in mysql? : Sql dba
What is synonyms?
Can we use loop in sql?
What is the difference between sql and isql*plus?
What does partition by mean in sql?
How do you update a sql procedure?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is the use of sqlerrd 3?
What is execute immediate?
What are all the ddl commands?
What is the difference between function and procedure in pl/sql?
How subquery works in sql?
How do I create a sql script?
What is integrity in sql?
Define join and name different types of joins?