MySQL Removing Some Foreign keys

by

As explained here, seems the foreign key constraint has to be dropped by constraint name and not the index name.

The syntax is:

ALTER TABLE footable DROP FOREIGN KEY fooconstraint;

More Related Contents:

  1. How to truncate a foreign key constrained table?
  2. How to remove constraints from my MySQL table?
  3. MySQL Creating tables with Foreign Keys giving errno: 150
  4. MySQL Error 1215: Cannot add foreign key constraint
  5. MySQL foreign key constraints, cascade delete
  6. How do I see all foreign keys to a table or column?
  7. MySQL Cannot Add Foreign Key Constraint
  8. How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. Basics of Foreign Keys in MySQL?
  11. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  12. MySQL – Conditional Foreign Key Constraints
  13. How do I use on delete cascade in mysql?
  14. Add Foreign Key to existing table
  15. How to change the foreign key referential action? (behavior)
  16. Unique constraint that allows empty values in MySQL
  17. Error renaming a column in MySQL
  18. A constraint to prevent the insert of an empty string in MySQL
  19. Show constraints on tables command
  20. MySQL foreign key to allow NULL?
  21. MySQL Errno 150
  22. Use Composite Primary Key as Foreign Key
  23. Foreign key constraints: When to use ON UPDATE and ON DELETE
  24. MySQL distinction between e and é (e acute) – UNIQUE index
  25. MySQL and Check Constraints
  26. MySQL DROP all tables, ignoring foreign keys
  27. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  28. MySQL errorno 121
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. MySQL Relationships

Leave a Comment