Re: Adding a Foreign Key without Constraints

[george gallen]

If I check off the "no SQL" box, it only creates the index - it doesn't actually add the foreign key relationship to the table. As for the NO ACTION, I'll have to play with that again, but I didn't think it worked. At least it wouldn't let me ALTER the table while it had a broken link. I'll have to see if copy off the data to a temp table, then see if I add in the FK constraint with NO ACTION, then copy the data back - if it will let me add a row with an invalid link.

Essentially, I want to be able to shoot myself in the foot while reading the book about gun safety!

I want to setup a FK relationship, but not actually have the database issue a constraint when it the relationship is bad. - More for documentation purposes. So if you look at the Table's schema you will see the FK.

Thanks