Carlos Brice?o

General Comments

• March 31, 2005

  Take this as an additional hint:

  select t1.owner, t1.table_name, t1.constraint_name, t1.column_name, 
  t1.position, t3.table_name parent_table, t3.column_name parent_column
  from user_cons_columns t1, user_constraints t2, user_cons_columns t3, user_constraints t4
  where t1.table_name = t2.table_name
  and   t1.constraint_name = t2.constraint_name
  and   t1.owner = t2.owner
  and   t2.CONSTRAINT_TYPE  = 'R'
  and   t4.constraint_type = 'P'
  and   t4.constraint_name = t2.r_constraint_name
  and   t4.OWNER = t2.R_OWNER
  and   t4.table_name      = t3.table_name
  and   t4.CONSTRAINT_NAME = t3.CONSTRAINT_NAME
  and   t4.owner = t3.owner
  and   t1.position = t3.position
  order by t1.table_name, t1.constraint_name, t1.position
  

  This query gives the columns involved in a referential integrity constraint in both tables. Is a bit time consuming but helps in case the column_names in both parent and children differ.

  Hope this helps

  
  
  -- (March 31, 2005) on Reverse Engineering a Data Model