Dropping Unique Constraint from MySQL table | MySQL Developer Tutorial | MySQL Tutorial

preview_player
Показать описание
How to drop Unique Constraint from MySQL Table demo explains how to drop the Unique Constraint. When you create Unique Constraint , it created the Unique Index on Table in MySQL, You will not see the unique constraint if you run describe tablename statement. If you are using MySQL workbench then you will find the Unique Constraint under Indexes.

You can use show index on tablename to check the indexes list and then can drop it.
link to scripts used in MySQL Developer Tutorial / MariaDB developer Tutorial

MySQL Tutorial for Beginners
MySQL Development Tutorial
MySQL Tutorial for developers
MySQL Development Training
MySQL training for developers
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin
Рекомендации по теме
Комментарии
Автор

you didn't show how to drop UNIQUE on single column!!??
why ?!!?

HammadKhan-ikru
Автор

I cant drop this one -
UNIQUE KEY (`customer_id`)
I tried -
DROP index on customer_prop_sell_alerts;
it says -
#1553 - Cannot drop index needed in a foreign key constraint

murilolivorato
join shbcf.ru