I have a customer table that several other tables can use. When they associate it, the related table has an entry of the primary key from customers. The customer table has not entry showing that it is being used in various tables.
From time to time I want to delete a customer but need to make sure that are not being used in the 1/2 dozen tables that might be in.
Is there an easy way to see, before deletion, if any relationships exist?
Thanks for any insight