Alter table - drop column with foreign key
Database management in a single PHP file
Brought to you by:
jakubvrana
If you try to drop a column, that references to another InnoDB table, you get an error like "Error on rename of './db/#sql-420_58' to './db/table' (errno: 150)".
You have to drop the foreign key first and then you can drop the column. Would be great if Adminer dropped the foreign key automatically on attempt to drop such column.
The column may be used in multi-column foreign key and it's not clear whether it should drop the whole foreign key or just the single column from it.