modify column name in sql

ALTER TABLE table_name
ALTER COLUMN column_name datatype;
--ex.
ALTER TABLE Customers
ADD Email varchar(255);

ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

ALTER TABLE users
 ALTER COLUMN first username varchar(20);

ALTER TABLE `db_name`.`table_name` 
	CHANGE `current_column_name` `new_column_name` datatype(size) NOT NULL COMMENT '';

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';