- Go to PHPMyAdmin
- Select Database
- Click Query Tab
Insert the following commands one by one make sure to change table_name with actual table name and column name with actual column name
First you need to remove foreign key from table.column
ALTER TABLE `table_name`
DROP FOREIGN KEY `table_name_column_name_foreign`;
Than remove index from table.column
ALTER TABLE `table_name`
DROP INDEX `table_name_column_name_foreign`;