[GH-ISSUE #17] Dropping foreign key columns #148

New issue

Open

opened 2026-03-07 20:41:32 +03:00 by kerem · 3 comments

kerem commented

2026-03-07 20:41:32 +03:00

Owner

Originally created by @majdzadeh on GitHub (Aug 9, 2016).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/17

Hi
When dropping foreign key columns using alter table statements, dbdiff uses "DROP CONSTRAINT". Instead, it should use "DROP FOREIGN KEY".

Originally created by @majdzadeh on GitHub (Aug 9, 2016). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/17 Hi When dropping foreign key columns using alter table statements, dbdiff uses "DROP CONSTRAINT". Instead, it should use "DROP FOREIGN KEY".

kerem commented

2026-03-07 20:41:34 +03:00

Author

Owner

@jasdeepkhalsa commented on GitHub (Aug 25, 2016):

@majdzadeh Could you please explain the difference and implications for us so we're clear? Thanks

@jasdeepkhalsa commented on GitHub (Aug 25, 2016): @majdzadeh Could you please explain the difference and implications for us so we're clear? Thanks

kerem commented

2026-03-07 20:41:34 +03:00

Author

Owner

@djshen-ponddy commented on GitHub (Aug 29, 2016):

According to official documentation, to drop foreign keys we should use DROP FOREIGN KEY instead of DROP CONSTRAINT

@djshen-ponddy commented on GitHub (Aug 29, 2016): According to [official documentation](http://dev.mysql.com/doc/refman/5.7/en/alter-table.html), to drop foreign keys we should use `DROP FOREIGN KEY` instead of `DROP CONSTRAINT`

kerem commented

2026-03-07 20:41:34 +03:00

Author

Owner

@jasdeepkhalsa commented on GitHub (Nov 24, 2017):

This is be part of the same cleanup as #41

@jasdeepkhalsa commented on GitHub (Nov 24, 2017): This is be part of the same cleanup as #41