Art S. Kagel
If there is a foreign key constraint, you can check on that in the sysmaster
> When I do a select on a record, is there a way that I can
> tell if it is
> being referenced by another table, and if so, can I tell by
> what table?
sending to informix-list
I have a central piece of information which is referenced from many
different tables. Now when someone wants to delete a record of this central
table I'd like to check beforehand whether this record is still referenced
by any of the other tables. Doing a count(*) on all these other tables would
be somewhat tedioius and error-prone because if antoher table will be added
sometime which would use this central information, too, there's a big chance
that at some time I'd forget to add the checking.
So, is there a way to determine whether a record is still referenced by any
foreign key anywhere (in the same database)?