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
What is type and rowtype in pl sql?
What is the difference between unique and primary key constraints?
What is pls_integer in pl sql?
What is dense_rank?
explain mysql aggregate functions. : Sql dba
Does user triggers have entry for trigger with compilation errors?
Can we use ddl commands in pl sql?
What type of database is sql?
What are sql commands?
How do I run a pl sql program?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is embedded sql what are its advantages?
explain access control lists. : Sql dba
How do I find sql profiler?
How to make a copy values from one column to another in sql?