declare
isexists number;
begin
select count(1) into isexists from user_constraints where constraint_type = 'ZCWX_WXBZMXB' AND table_name = 'ZCWX_WXBZMXB' ;
if isexists = 1
then
execute immediate 'alter table zcwx_wxbzmxb drop constraint ZCWX_WXBZMXB ';
end if;
commit;
end;
Oracle取消主键约束
最新推荐文章于 2024-07-15 18:07:55 发布