In OceanBase Database, you can add, modify, and drop a primary key.
Add a primary key
The syntax for adding a primary key is as follows:
ALTER TABLE table_name ADD PRIMARY KEY (column_name);
Here is an example:
obclient> CREATE TABLE tbl1(c1 INT,c2 VARCHAR(50));
Query OK, 0 rows affected
obclient> ALTER TABLE tbl1 ADD PRIMARY KEY(c1);
Query OK, 0 rows affected
Modify a primary key
The syntax for modifying a primary key is as follows:
ALTER TABLE table_name MODIFY PRIMARY KEY (column_name);
Here is an example:
obclient> ALTER TABLE tbl1 MODIFY PRIMARY KEY (c2);
Query OK, 0 rows affected
Drop a primary key
The syntax for dropping a primary key is as follows:
ALTER TABLE table_name DROP PRIMARY KEY;
Here is an example:
obclient> ALTER TABLE tbl1 DROP PRIMARY KEY;
Query OK, 0 rows affected