User_constraints

List Tables That Are Using the Specified Table as a Foreign Key using dba_constraints Which tables point at SALES.CUSTOMER? You need the answer before you truncate it, drop it, reload it or change its primary key, because every child table with a foreign key to it will either block the change or be affected by it. …