-------------------------------------------------------------------------
--   description: script to report the constraints that apply to a table
--                -- particularly useful when you need to disable them to
--                drop or truncate the table!
--        author: D. Clement
--          date: 9 July 2004
-------------------------------------------------------------------------
select owner "Owner", 
    constraint_name "Constraint", 
    constraint_type "Type", 
    status "Status"
from user_constraints
where r_constraint_name in
    (select constraint_name
    from user_constraints
    where table_name = '&&tn');