The DEALLOCATE PREPARE and DROP PREPARE statements are used interchangeably and they clear the prepared statement. All prepared statements are cleared automatically by the server when the client session is terminated even if the DEALLOCATE PREPARE or DROP PREPARE statement is not executed.
{DEALLOCATE | DROP} PREPARE stmt_name
DEALLOCATE PREPARE stmt1;