Subject Re: [firebird-support] Detect FK usage
Author Helen Borrie
At 12:02 PM 9/11/2004 -0500, you wrote:

>There is probably no easy way to do this...
>I have a table that has many inbound FKs on it. I only want entries in this
>table to be editable or deletable if they are not in use yet by any other
>tables. For delete its easy, I try to delete and if its in use it fails.
>But for edit - how can I determine easily if its already in use and then
>decide to allow it to be updated or not? I don't want to hard code checks
>against every table as this will lead to bugs in the application code in the
>future as more tables are added.

The referential integrity checks take care of this.