In MySQL mode of OceanBase Database, you can add and drop foreign keys.
Add a FOREIGN KEY constraint
Syntax:
ALTER TABLE table_name ADD CONSTRAINT fk_name FOREIGN KEY(column_name)
REFERENCES table_name(column_name);
Sample code:
obclient> CREATE TABLE t1(c1 INT,c2 VARCHAR(50));
Query OK, 0 rows affected
obclient> CREATE TABLE t2(c1 INT PRIMARY KEY,c2 VARCHAR(50));
Query OK, 0 rows affected
obclient> ALTER TABLE t1 ADD CONSTRAINT fk1 FOREIGN KEY(c1) REFERENCES t2(c1);
Query OK, 0 rows affected
DROP FOREIGN KEY
Syntax:
ALTER TABLE table_name DROP FOREIGN KEY fk_name;
Sample code:
obclient> ALTER TABLE t1 DROP FOREIGN KEY fk1;
Query OK, 0 rows affected