首先，要搞清楚user_cobnstraints 中的每个column时是什么意思。R_CONSTRAINT_NAME
Name of unique constraint definition for referenced table
CONSTRAINT_NAME
Name associated with constraint definition所以，你的SQL 是错的select a.constraint_name as 表名,b.column_name as 列名 from user_constraints a,user_cons_columns b where a.table_name='DB_CNTRD' and a.constraint_type='R' and a.constraint_name=b.constraint_name and b.column_name='CODE'
Name of unique constraint definition for referenced table
CONSTRAINT_NAME
Name associated with constraint definition所以，你的SQL 是错的select a.constraint_name as 表名,b.column_name as 列名 from user_constraints a,user_cons_columns b where a.table_name='DB_CNTRD' and a.constraint_type='R' and a.constraint_name=b.constraint_name and b.column_name='CODE'
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货