1.查询出所有表的唯一键约束的 禁用sql
select 'alter table ' || table_name || ' disable constraint '||constraint_name||';'
from user_constraints where constraint_type='U';
如下:
alter table SYENTINFO2 disable constraint UQ_SY20180806;
alter table WEB_INFO disable constraint UQWEBINFO201807211136;
alter table ENT_INFO_WUHAN disable constraint SYS_C0024733;
2.查询出所有表的唯一键约束的 启用sql
select 'alter table ' || table_name || ' enable constraint '||constraint_name||';'
from user_constraints where constraint_type='U';
如下:
alter table SYENTINFO2 enable constraint UQ_SY20180806;
alter table WEB_INFO enable constraint UQWEBINFO201807211136;
alter table ENT_INFO_WUHAN enable constraint SYS_C0024733;
3.查询所有表的所有外键
select 'alter table ' || table_name || ' enable constraint '||constraint_name||';'
from user_constraints where constraint_type='R';
来源注:https://st4024589553.iteye.com/blog/2430129