How to Delete a Foreign Key Constraint in MySQL?

Deleting Foreign Keys from a MySQL Table

Foreign keys establish relationships between tables, ensuring data integrity. However, situations may arise where you need to remove a foreign key constraint. This question explores how to drop a foreign key column from a table without encountering an error.

As detailed in the provided scenario, an attempt to delete the foreign key column "locationIDX" from the "assignment" table results in an error ("ERROR 1025"). This error occurs because foreign key constraints are identified by their constraint names rather than index names.

To successfully drop the foreign key constraint, you must specify its name. The correct syntax for this operation is:

ALTER TABLE footable DROP FOREIGN KEY fooconstraint;

Replacing "footable" with the table name ("assignment") and "fooconstraint" with the foreign key constraint name will enable you to drop the column without triggering an error.

The above is the detailed content of How to Delete a Foreign Key Constraint in MySQL?. For more information, please follow other related articles on the PHP Chinese website!