Reference and syntax for the DROP ENGINE command.
DROP ENGINE [IF EXISTS] <engine_name>
<engine_name>
DROP ENGINE my_engine