Drop column stored procedure for mysql

drop_column_if_exist.sql

DROP PROCEDURE IF EXISTS drop_column_if_exist;

DELIMITER ';;'
CREATE PROCEDURE drop_column_if_exist(IN schemaName CHAR(255), IN tableName CHAR(255), IN columnName CHAR(255)) BEGIN
  IF exists(
      SELECT *
      FROM information_schema.columns
      WHERE table_schema = schemaName AND table_name = tableName AND column_name = columnName)
  THEN
    SET @query = CONCAT('ALTER TABLE ', tableName, ' DROP COLUMN ', columnName, ';');
    PREPARE stmt FROM @query;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
  END IF;
END;;

DELIMITER ';'
CALL drop_column_if_exist(SCHEMA(), 'table', 'column');

DROP PROCEDURE IF EXISTS drop_column_if_exist;