Cant drop key mysql

When adding a new key and pushing to DB, it will not allow you to drop the key and push to db.

1 Reply

skuseOP•2y ago

the code it attempts to execute is:

'ALTER TABLE `Attribute` DROP CONSTRAINT `Attribute_tokenAttributeId_key`;'

'ALTER TABLE `Attribute` DROP CONSTRAINT `Attribute_tokenAttributeId_key`;'

whereas it should be:

ALTER TABLE `Attribute` DROP INDEX `Attribute_tokenAttributeId_key`;

ALTER TABLE `Attribute` DROP INDEX `Attribute_tokenAttributeId_key`;

this is for dropping unique constraint. I havent tested it with other keys