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
Explain cursor types?
define sql insert statement ? : Sql dba
List the various privileges that a user can grant to another user?
What is character functions?
How do I run pl sql in sql developer?
What is replication id?
How can I tell if sql is running?
Can sql developer connect to db2?
What is trigger explain with example?
how do you know the version of your mysql server? : Sql dba
What is sql and its types?
How to write a query to show the details of a student from students table whose
In pl/sql, what is bulk binding, and when/how would it help performance?
what happens if null values are involved in expressions? : Sql dba
Can we create clustered index without primary key?