Mysql - DROP THE FOREIGN KEY or CONSTRAINT

 

Show the FOREIGN KEY or CONSTRAINT

SHOW CREATE TABLE <table_name>;

OR

use INFORMATION_SCHEMA;
select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE
where TABLE_SCHEMA = "<your_database_name>" and TABLE_NAME = "<your_table_name>"

 

Drop the FOREIGN KEY or CONSTRAINT

alter table <table_name> drop foreign key <FK_name_of_foreign_key_or_constraint>;

 

 

Take a look a Mysql  ALTER TABLE Syntax