The tables in our database application have referential integrity, and
mostly
linked to the primary table. Somehow the relation****p links dropped a
couple
of weeks ago during some modification/im****ting data process. We did not
notice that. So, I assume if I delete data from primary table, the cascade
update/delete did not work.
I am asking for help here, what are the possible reasons that tables could
drop the relation****p? Could anyone give me some suggestions of how to fix
the problem?