Renaming the column name in SQL without data loss

EXECUTE sp_rename 'SchemaName.TableName.CurrentColumn', 'New Column', 'COLUMN';