oracle查看禁用/启用/删除外键约束sql

时间：2018-10-11 14:07:29 收藏：0 阅读：241

1、查看禁用外键sql

select ‘alter table ‘||table_name||‘ disable constraint ‘||constraint_name||‘;‘ from user_constraints where constraint_type=‘R‘;

2、查看启用外键sql

select ‘alter table ‘||table_name||‘ enable constraint ‘||constraint_name||‘;‘ from user_constraints where constraint_type=‘R‘;

3、查看删除外键sql

select ‘alter table ‘||table_name||‘ drop constraint ‘||constraint_name||‘;‘ from user_constraints where constraint_type=‘R‘;

原文：https://www.cnblogs.com/Knight7971/p/9772012.html