How to Change a column name in a table

[titans4771]

I have tried to change a column in my table several ways:

ALTER TABLE ClientIDtoClientRollup RENAME COLUMN Description to RollupDesccription;

ALTER table ClientIDtoClientRollup change Description RollupDesccription varchar(255)

They both returns errors:

Incorrect syntax near the keyword 'COLUMN'

Line 1: Incorrect syntax near 'Description'

Please advise!!!

Thanks!

 

[gmmastros]

Before you run the following command, notice that description is spelled wrong. You have 2 c's.

sp_rename 'ClientIDtoClientRollup.Description', 'RollupDes[!]cc[/!]ription', 'COLUMN'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

set ansi_warnings off


create table Test ([Description] varchar(20))
select * from Test 
EXEC sp_rename 
    @objname = 'Test.[Description]', 
    @newname = '[Rollup_Description]', 
    @objtype = 'COLUMN'
go

select * from Test

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/

 

[titans4771]

Thanks!