Plsql search constraints

From John Freier
Revision as of 11:33, 3 October 2023 by Jfreier (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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%';