Dropping Unique Constraint from MySQL table - MySQL Developer Tutorial

Dropping Unique Constraint from MySQL table

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 create table tablename;" or you can use "show index from tablename;" to get information for Unique Constraint on Table. Once you know the name of Unique Constraint, you can use below statement to drop the Unique Constraint in MySQL.

drop index Unique_Constraint_Name on TableName;

Video Demo : How to check Unique Constraint on Table and Drop Unique Constraint in MySQL

No comments:

Post a Comment