Листинг 2. Обработка стандартной информации

Create view fe_v_ref_info 
as
select 
 upper(sc1.table_name)  PrimTab_Eng,
 upper(sc1.column_name)  PrimFieldEng,
 upper(sr.unique_constraint_name)FirstConstr,
 upper(sc2.table_name)  SecondTab_Eng,
 upper(sc2.column_name)  SecondFieldEng,
 upper(sr.constraint_name) SecondConstr
from 
 information_schema.referential_constraints sr,
 information_schema.constraint_column_usage sc1,
 information_schema.constraint_column_usage sc2
where 
 upper(sr.unique_constraint_name)=upper(sc1.constraint_name)
 and upper(sr.constraint_name)=upper(sc2.constraint_name)