Foreign Key constraint check

Foreign Key constraint check

El Forum
Unregistered

05-25-2009, 09:41 AM

[eluser]Jagar[/eluser]
I guess there is no solution to this, so this is what I'm going to do now.

Before deleting a row from a table that is a foreign key of another table, I will check all the tables, and see if the id exist on them, and return true or false.

If there's a better way to do this and efficient way, please let me know.

Thanks

Messages In This Thread

Foreign Key constraint check - by El Forum - 05-23-2009, 09:14 PM

Foreign Key constraint check - by El Forum - 05-24-2009, 12:14 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:14 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:19 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:24 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:31 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:36 AM

Foreign Key constraint check - by El Forum - 05-25-2009, 09:41 AM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:11 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:14 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:28 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 01:43 PM

Foreign Key constraint check - by El Forum - 04-05-2011, 01:58 PM

Foreign Key constraint check - by El Forum - 04-05-2011, 11:34 PM

Foreign Key constraint check - by El Forum - 04-06-2011, 01:26 PM