人大金仓数据库添加外键,删除外键

// 添加外键
ALTER TABLE "sec_permissions" ADD CONSTRAINT fke086556228cd079 FOREIGN KEY(perm_parent_id) REFERENCES "sec_permissions" 
ON DELETE NO ACTION 
ON UPDATE NO ACTION 
ENABLE VALIDATE;

// 删除外键
ALTER TABLE "sec_permissions" DROP CONSTRAINT "fke086556228cd079";

 

posted @ 2021-07-24 14:09  Nihaorz  阅读(951)  评论(0编辑  收藏  举报