Oracle创建删除的外键脚本

select 'alter table ' || table_name || ' ' ||

       'drop constraint ' || constraint_name || ' ;'

  from user_constraints

where constraint_type = 'R';