Plsql search constraints

From John Freier
Jump to: navigation, search

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%';