sql change column name dynamically code example
Example 1: how to change a collumn name in sql
ALTER TABLE `table_name`
CHANGE `old_name` `new_name` VARCHAR(10)
CHARACTER SET utf8
COLLATE utf8_general_ci NULL
DEFAULT NULL;
Example 2: change column name sql
ALTER TABLE `db_name`.`table_name`
CHANGE `current_column_name` `new_column_name` datatype(size) NOT NULL COMMENT '';