查寻unique constraint 是对哪个表的约束
查找unique constraint 是对哪个表的约束
问题描述:程序运行时,报unique constraint (VOCY.CNM_CH) violated
怎么确认违反了哪个表的约束呢?
解决方案:
desc all_objects select * from all_objects where object_name like '%CNM%'; desc USER_CONS_COLUMNS; select * from user_cons_columns t where t.constraint_name like '%CNM%'