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
Is not equal in sql?
How do I remove sql plus from windows 10?
What is the use of double ampersand (&&) in sql queries? Give an example
What is the maximum rows in csv?
What packages are available to pl/sql developers?
how to convert character strings to dates? : Sql dba
Show how functions and procedures are called in a pl/sql block.
What is indexing in sql and its types?
How to execute a stored procedure?
what is a join? : Sql dba
Can we commit in trigger?
Is mariadb nosql?
Explain what is a subquery ?
What is a full join sql?
what is blob? : Sql dba