Difference between revisions of "Plsql search constraints"

Latest revision as of 10:33, 3 October 2023

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