how to change the column name in sql

1EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

1ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

1ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

1ALTER TABLE table_name
2CHANGE COLUMN old_name TO new_name;
3

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

1-- Microsoft SQL style
2EXEC sp_rename 'TableOldName', 'TableNewName';