Sql Drop Constraint Unique Not Working

I got the following table: CREATE TABLE `unsub_counts` ( `count_id` int(11) NOT NULL AUTO_INCREMENT, `unsub_date` date DEFAULT NULL, `unsub_count` int(11) DEFAULT NULL, `store_

Solution 1:

Use drop index with constraint name:

ALTERTABLE unsub_counts DROP INDEX uc_unsub_date;

or just:

drop index uc_unsub_date on unsub_counts;