Cacher is the code snippet organizer for pro developers

START TRANSACTION;

ALTER TABLE applicant DROP COLUMN type;
/* if you need Role back run(ROLLBACK)*/
ROLLBACK;
/*or if you are finaly ok & want to submit this code.*/
COMMIT ;