H2删除外键-新增外键

如果不确定外键约束的名称，可以通过`SHOW CREATE TABLE`命令查看表创建语句中系统定义的外键名。
CONSTRAINT ACT_FK_VAR_BYTEARRAY FOREIGN KEY (BYTEARRAY_ID_) REFERENCES PUBLIC.ACT_GE_BYTEARRAY(ID_) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT ACT_FK_VAR_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ON DELETE RESTRICT ON UPDATE RESTRICT
使用`ALTER TABLE`语句删除外键约束，语法为`ALTER TABLE 表名 DROP FOREIGN KEY 外键名`。这里的外键名是指外键约束的名称，而不是外键字段。
ALTER TABLE ACT_RU_VARIABLE DROP FOREIGN KEY ACT_FK_VAR_EXE;-- mysql数据库删除外键
ALTER TABLE PUBLIC.ACT_RU_VARIABLE DROP CONSTRAINT ACT_FK_VAR_EXE; -- H2数据库删除外键
-- H2数据库 修改外键
-- H2数据库 新增外键
-- 删除和修改的限制为：约束
ALTER TABLE PUBLIC.ACT_RU_VARIABLE ADD CONSTRAINT ACT_FK_VAR_EXE2 FOREIGN KEY (EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ON DELETE RESTRICT ON UPDATE RESTRICT;
-- 删除的限制：无动作，修改的限制：约束
ALTER TABLE PUBLIC.ACT_RU_VARIABLE ADD CONSTRAINT ACT_FK_VAR_EXE2 FOREIGN KEY (EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_) ON UPDATE RESTRICT;
-- 删除的限制：无动作，修改的限制：无动作
ALTER TABLE PUBLIC.ACT_RU_VARIABLE ADD CONSTRAINT ACT_FK_VAR_EXE2 FOREIGN KEY (EXECUTION_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_);