sp_rename '{table_name}.{column_old_name}', '{column_new_name}', 'COLUMN';

Microsoft recommends that you drop and recreate the table so that scripts and stored procedures are not broken.

https://www.techonthenet.com/sql_server/tables/alter_table.php