Change column name in T-SQL

[agoeddeke]

Hello,

Is there any way to change a column name in T-SQL using ALTER TABLE or something?

I'd like to rename a column yet still keep it's same ordinal position.

Thanks,
Andy

 

[hmckillop]

This shows you how to change a column

CREATE TABLE doc_exa ( column_a INT)
GO
ALTER TABLE doc_exa ALTER COLUMN column_a NVARCHAR(20) NOT NULL
GO
EXEC sp_help doc_exa
GO
DROP TABLE doc_exa
GO

 

[SmileyConspiracy]

Probably the easiest way of renaming an object is to use sp_rename. For a column you would use some thing like this.

EXEC sp_rename 'ColumnName', 'NewName', 'COLUMN'

 

[agoeddeke]

Thanks furbank,

SP_RENAME does the trick.

Andy