The following sql statement allows you to view the relationships between primary keys and foreign keys with other tables. SELECT uc.constraint_name||CHR(10) || '('||ucc1.TABLE_NAME||'.'||ucc1.column_name||')' constraint_source , 'REFERENCES'||CHR(10) || '('||ucc2.TABLE_NAME||'.'||ucc2.column_name||')' references_column FROM user_constraints uc , user_cons_columns ucc1 , user_cons_columns ucc2 WHERE uc.constraint_name = ucc1.constraint_name AND uc.r_constraint_name = ucc2.constraint_name and ucc1.position = ucc2.position AND uc.constraint_type = 'R' --AND uc.constraint_name = 'FKF32F2C126588DBBC' order by ucc1.table_name , uc.constraint_name; CONSTRAINT_TYPE (from 11gR2 docs) C - Check constraint on a table P - Primary key U - Unique key R - Referential integrity V - With check option, on a view O - With read only, on a view H - Hash expression f - cons