[Solved] How to rename a column in SQL Server 2005 [duplicate]

by


Its a old version of mssql so does not support above solutions but when i tried like this it works

EXEC sys.sp_rename 'fg.TABLE NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME','COLUMN';

anyway thanks for your efforts

solved How to rename a column in SQL Server 2005 [duplicate]