Plsql search constraints
From John Freier
Run the query below to search for information on constraints.
- OWNER = Schema
- FK_NAME = Constraint name
select * from all_constraints where 1=1 --and owner = 'OWNER' and constraint_name LIKE '%FK_NAME%';