MySQL: alter unique key name?

Question

I want to rename "InputOutputConfigurationServerAccountId" to "CompositeKey". How do I do this via SQL?

Part of my table definition:

UNIQUE KEY `InputOutputConfigurationServerAccountId` (`InputOutputConfigurationServerAccountId`,`Identifier`,`TimeStampReceived`)

The table is already in production. I am trying to alter the table.

Possible duplicate of http://stackoverflow.com/questions/1463363/how-do-i-rename-an-index-in-mysql — Michael Mior, Jul 19 '11 at 00:52

score 7 · Accepted Answer · edited Jun 20 '13 at 09:47

7

Yep Femi is right. it would be done like this:

ALTER TABLE `test`.`UniqueKeys` 

DROP INDEX `InputOutputConfigurationServerAccountId`, 
ADD UNIQUE INDEX `CompositeKey` (`InputOutputConfigurationServerAccountId`,
`Identifier`,`TimeStampReceived`) ;

edited Jun 20 '13 at 09:47

jmruc

5,714
3
22
41

answered Jul 19 '11 at 00:53

Edgar Velasquez Lim

2,426
18
15

score 1 · Answer 2 · answered Jul 19 '11 at 00:52

1

There is currently no support in MySQL's ALTER syntax to rename a key. You will have to create a new composite key and drop the old one.

answered Jul 19 '11 at 00:52

Femi

64,273
8
118
148

MySQL: alter unique key name?

2 Answers2