togetamoredetaileddescription (which table/columnreferenceswhichtable/column ) you can run the following query :
slect UC.constraint _ name|||chr (10 )
||'|| UC C1.table _ name|| '.'|| UC C1.column _ name|||' ) ' constraint_source
、' references'||chr(10 ) )。
||'|| UC C2.table _ name|| '.'|| UC C2.column _ name|||' ) ' references_column
FROM user_constraints uc,
user_cons_columns ucc1,
user_cons_columns ucc2
were UC.constraint _ name=UC C1.constraint _ name
anduc.r _ constraint _ name=UC C2.constraint _ name
and UCC1. position=UCC C2.position-- correctionformultiplecolumnprimarykeys。
AND uc.constraint_type='R '
anduc.constraint _ name=' sys _ c 00381400 '
ORDER BY ucc1.TABLE_NAME,
uc.constraint_name;
来自中心。