You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Support dropping multi-foreign-keys in one statement, the syntax as follows:
ALTER TABLE tbl_name
[alter_specification [, alter_specification] ...]
alter_specification:
DROP FOREIGN KEY fk_symbol
e.g.
create table t1 (a int, b int, key(a), key(b));
create table t2 (c int, CONSTRAINT a foreign key (c) references t1(a), CONSTRAINT b foreign key (c) references t1(b));
alter table t2 drop foreign key a, drop foreign key b;
The text was updated successfully, but these errors were encountered:
Description
Support dropping multi-foreign-keys in one statement, the syntax as follows:
e.g.
The text was updated successfully, but these errors were encountered: