Quote:
Originally Posted by pratikp.vasani
Hello,
I have two tables the Main table and the Child table.
The Main table has primary keys and thye child table has the foreign keys refering to the primary keys of the Main table.
Can I make the foreign keys as the primary keys also in the Child table?
Or only the foreign keys ias enough.
|
Yes, you can do that, but the question is why do you have two different tables with the same PK? If you are doing that for some extreme performance requirement then it might be OK, but it is not 3rd normal form.