Fk Referenced Tables

[julian]

Originally posted by jmodic
More something like that:

SELECT DISTINCT ac.owner, ac.table_name
FROM ALL_CONSTRAINTS ac
WHERE ac.constraint_type IN ('P','U')
AND EXISTS (SELECT NULL FROM ALL_CONSTRAINTS
            WHERE constraint_type = 'R'
            AND r_owner = ac.owner
            AND r_constraint_name = ac.constraint_name);

Same thing :-) You only list additionally the owner.