Renaming the column name in SQL without data loss

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

Spotfire Interview Questions

https://intellipaat.com/interview-question/spotfire-interview-questions/?utm_source=link%2Fsfiq_MF&utm_medium=posting&utm_campaign=link%2Fsfiq_MF%20posting