To remove a primary key following SQL query may be used:
1
MODIFY TABLE table_name
DROP PRIMARY KEY
[CASCADE];
2
ALTER TABLE table_name
DROP PRIMARY KEY
[CASCADE];
3
DELETE PRIMARY KEY
FROM table_name:
4
CHANGE TABLE table_name
DELETE PRIMARY KEY;
5
ALTER TABLE table_name
REMOVE PRIMARY KEY
[CASCADE];