Difference between revisions of "Plsql search constraints"

From John Freier
Jump to: navigation, search
(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%';')
(No difference)

Revision as of 12:54, 17 December 2012

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