一.思路1
1.select * from dba_constraints
where owner='INFORES_GZ_PJ2'
AND CONSTRAINT_NAME='FK_TC_DEV_PROPERTY_GRP_PROID'

2.SELECT * FROM DBA_SEGMENTS
WHERE SEGMENT_NAME='TC_DEV_PROPERTY_GRP'
AND OWNER='INFORES_GZ_PJ2'
3.用PL/SQL DEVELOPER查看表的索引或约束字段
3.1使用包查看set long 10000
select dbms_metadata.get_ddl('TABLE','TABLE_NAME','OWNER') FROM DUAL;
4.查看外键表是否含有相关字段内容;