CODEWITHSUNDEEP
mysqlspring-bootflyway
Mohammad Quadri
Mohammad Quadri

Reputation: 395

You have an error in your SQL syntax; ... 'UNIQUE `UK6i9q4suadww4j167aqe2h6aqj`' at line 4

I am trying to remove Unique constraint from a column using flyway DB migration in spring-boot. But I am not able to figure out the right query for that. Here is my existing query

ALTER TABLE `choices` DROP UNIQUE `UK6i9q4suadww4j167aqe2h6aqj`;

Here is the error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE `UK6i9q4suadww4j167aqe2h6aqj`' at line 4

Note: the above query is working fine if I am running it through PHPMyAdmin. Its ask for confirmation and then remove it.

Upvotes: 0

Views: 128

Answers (1)

nbk
nbk

Reputation: 49385

Use

ALTER TABLE `choices` DROP index `UK6i9q4suadww4j167aqe2h6aqj`;

This will only work , if there in no foreign key defined that references your key. . In which case you have to drop the foreign keys first.

Upvotes: 1

Related Questions