Hello everyone,
does anyone know how to find out whether a row is currently referenced by a row in a different table? They are bound together by a foreign key constraint.
The reason why I would like to know this is that I would like to be able to delete rows only if they aren't used anywhere. If this can't be done by a single query, does anyone have such a function they could share or at least a few hints where I could look for more information?
It occurred to me that I could create a function that would query a system table for all references to the table the row would be deleted from and then scan tables that refer to that one, but I was hoping there would be a simpler and maybe a more efficient way to do this.
Thanks in advance.
Peter