I cant delete a table and I have tried everything.
I have a table called users with a field called role_id which wont delete. Then I have a table called roles which wont delete.
For the users table I do this and #1091 - Can't DROP 'role_id'; check that column/key exists
ALTER TABLE users DROP FOREIGN KEY role_id
if I drop table roles I get this
1217 - Cannot delete or update a parent row: a foreign key constraint fails