How can I rename primary key constraint in MySQL?

Question

I have several tables with primary keys. I did not give these primary keys constraints any name. Is it possible to give them name now and how? I am using MySQL 5.7.

Possible duplicate of http://stackoverflow.com/q/1463363/2037090 — Irvin Lim, Jun 20 '16 at 17:09
The name of a PRIMARY KEY is always PRIMARY, which thus cannot be used as the name for any other kind of index. — Ranjeet Singh, Jun 20 '16 at 18:01

Syed Haris Ali Ghaznavi · Answer 1 · 2016-06-20T18:53:58.010

0

Try this

ALTER TABLE `mytable`
DROP PRIMARY KEY,
CHANGE COLUMN oldname newname INT(11) DEFAULT NULL,
ADD CONSTRAINT `mytable_newname_pk` PRIMARY KEY (`newname`)

edited Jun 20 '16 at 18:53

answered Jun 20 '16 at 18:47

Syed Haris Ali Ghaznavi

745
1
12
32

How can I rename primary key constraint in MySQL?

1 Answers1