Customer Contact Relationships

Is there a way to identify all the tables that are related to specific table? I’m particularly interested in Customer Contact Records. We have lots of ‘dead’ customer contact records that we’d like to remove from the database. My understanding is that if there aren’t any records elsewhere in the database that reference a particular customer contact (e.g. no transactions), the contact record could be deleted. I suppose we could do a DMT delete import against a list of contacts (XLS sheet), if referential integrity prevents a record from being deleted, the resulting ‘error’ might point at the table with the associated record. Does anyone have any familiarity with this?

As an alternative you could just mark them Inactive and you would not have to worry about tracking any references down.