Plsql search constraints

From John Freier
Revision as of 13:56, 17 December 2012 by Jfreier (Talk | contribs)

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