Foreign Key references multiple tables

Asked Jun 11 '15 at 08:57

Active Jun 11 '15 at 08:57

Viewed 188 times

I have 3 tables :

--table A
ID INT
Description VARCHAR(8000)

--table B
ID INT
Description VARCHAR(8000)

--table C
ID INT
ObjectID INT
Type CHAR(1)

ObjectID column in table C contains ID from either table A or table B, for example

ID          ObjectID    Type
----------- ----------- ----
3           10          A

Result above means the ID with value 10 is coming from table A. I need to put foreign key on ObjectID column that references to ID column in both table A and table B. Is this possible?

asked Jun 11 '15 at 08:57

tickwave

3,335
6
41
82

1

ref: http://stackoverflow.com/questions/7844460/foreign-key-to-multiple-tables – Saravana Kumar Jun 11 '15 at 09:04
[I've answered a similar question a while ago.](http://stackoverflow.com/questions/30539129/a-flexible-foreign-key/30539462#30539462) – Zohar Peled Jun 11 '15 at 09:05
http://www.sqlservercentral.com/Forums/Topic1540629-3077-1.aspx – Saravana Kumar Jun 11 '15 at 09:43

Foreign Key references multiple tables

0 Answers0