This might be a silly question. But can you have the following:

1 Table with Primary Key, 2 different tables each with a foreign key referencing the first table Primary key?

I know its possible to have 2 foreign keys in the same table, but the request I received was for the the below scenario:

enter image description here

  • 1
    It is absolutely common situation.
    – Akina
    Commented Jan 29, 2019 at 8:05

1 Answer 1


Why shouldn't it be possible? Suppose table1 holds all countries, table2 all cities and table3 has another foreign key to a table with all international organisations. They both need a foreign key to a country. You can even have a table4 that holds all regions. It also needs a foreign key to table1.

  • I kept on receiving error, dropped and recreated table with FK constraint and it went through. Like i said, silly question, But thanks for clarifying Commented Jan 29, 2019 at 8:37
  • 1
    There are no silly questions. Only silly answers :-)
    – Marco
    Commented Jan 29, 2019 at 9:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.