MySQL CONSTRAINT KEY torles

SHOW CREATE TABLE table;

use CONSTRAINT and KEY!!!

ALTER TABLE table_name
DROP FOREIGN KEY the_name_after_CONSTRAINT,
DROP KEY the_name_after_FOREIGN_KEY;