Plsql search constraints

From John Freier
Revision as of 12:54, 17 December 2012 by Jfreier (Talk | contribs) (Created page with 'Run the query below to search for information on constraints. select * from all_constraints where 1=1 --and owner = 'OWNER' and constraint_name LIKE '%FK_NAME%';')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Run the query below to search for information on constraints.

select * 
from all_constraints
where 1=1
--and owner = 'OWNER'
and constraint_name LIKE '%FK_NAME%';