Can a table have two primary keys?
- 44 Answers
- 84673 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answer Posted / subbu
Well the question is
Can a table have two primary keys?
Practically Yes.
But theoritically there will be only 1 primary key with
multiple foriegn keys which acts as a composite keys for the
original primary key. How ever in the create or alter
statements, we need to write primary key only once following
the column names either single or multiple.
By seeing the posts, I believe some of the guys has got
confused with the question & compared it with the SQL create
statements where in Primary Key is written only once & by
which concluding that a table cannot have multiple primary keys.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can one improve the performance of sql*loader? : aql loader
what is the bond code in materialized view?
Can we create table inside stored procedure?
Is left join inner or outer?
Is record in oracle pl sql?
What is trigger explain it?
what is oracle database ? : Sql dba
How many triggers can be applied to a table?
Can you load data into multiple tables at once? : aql loader
What is sql keyword?
Where not exists in sql?
What are % type and % rowtype?
What is the difference between rename and alias?
What are sql procedures?
What is the sql*loader? : aql loader
