Can a table have two primary keys?
Answer Posted / vineet
A Table can have only one primary key but it is possible to
have more than 1 primary key attributes i.e candidate key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is Materialized View? In What Scenario we Use Materialized View?
What are different types of indexes?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
how to see the create table statement of an existing table? : Sql dba
Can we commit inside a trigger?
How do you update a sql procedure?
how can you see all indexes defined for a table? : Sql dba
what is the difference between inner and outer join? Explain with example. : Sql dba
How do I create a sql database?
What is primary key secondary key alternate key candidate key?
When do we use triggers?
What is cursor in pl sql?
What is the use of primary key?
What is auto increment in sql?
What is the difference between stored procedure and view?