Foreign keys in databases referencing multiple tables

Question

Is it possible for a foreign key to reference several tables?

If not, how can we achieve one table linking to several others if not using the foreign key?

If yes, how?

A single foreign key can only reference two tables. However, You can specify multiple foreign keys between multiple tables. — Zohar Peled, Jun 19 '16 at 12:24
Possible duplicate of [Foreign Key to multiple tables](http://stackoverflow.com/questions/7844460/foreign-key-to-multiple-tables) — Liam, Oct 06 '16 at 08:56

score -1 · Answer 1 · answered Jun 19 '16 at 12:22

-1

You can declare as foreign keys as you need every one for one table

answered Jun 19 '16 at 12:22

Plebios

835
1
7
17

Pini Cheyni · Accepted Answer · 2016-06-30T07:18:06.750

-1

I'm not sure that I understand your question but if you mean two tables will reference a third table it is possible but if you mean connection of many to many between tables then you will have create another table which will hold both foreign keys.

edited Jun 30 '16 at 07:18

answered Jun 19 '16 at 12:24

Pini Cheyni

5,073
2
40
58

thanks, i actually found out that you can not use one foreign key to reference more than one other table. – timothy opiyo Jun 29 '16 at 12:04

score -1 · Answer 3 · answered Jun 19 '16 at 12:31

-1

You can always link any two tables through a join in a query, provided you can devise some boolean expression which defines the relationship.

answered Jun 19 '16 at 12:31

Kevin Anderson

4,568
3
13
21

another method is to use joins, that worked well, thanks. – timothy opiyo Jun 29 '16 at 12:05

Foreign keys in databases referencing multiple tables

3 Answers3