删除外键存储过程
CREATE OR REPLACE PROCEDURE DROP_ALL_FOREIGNKEY AS
V_RESULT_STRING VARCHAR2(2000);
BEGIN
FOR X IN (SELECT CONSTRAINT_NAME CNAME,TABLE_NAME TNAME FROM USER_CONSTRAINTS WHERE CONSTRAINT_TYPE='R') LOOP
V_RESULT_STRING := ‘ALTER TABLE ‘ || X.TNAME || ‘ DROP CONSTRAINT ‘ || X.CNAME;
EXECUTE IMMEDIATE V_RESULT_STRING;
END LOOP;
END;
声明: 除非转自他站(如有侵权,请联系处理)外,本文采用 BY-NC-SA 协议进行授权 | 智乐兔
转载请注明:转自《删除外键存储过程》
本文地址:https://www.zhiletu.com/archives-385.html
关注公众号:
微信赞赏支付宝赞赏