Change Column Name

[jmiller79]

How do i change the column name withouth changing any formats?


Thank You

 

[StevenK]

You could change the name of the field via SQL Server Enterprise Manager (if you mean at the database level) ?
If you want to change the name of a field in the result set of a query then you can make use of Aliasing - i.e.
SELECT Field1 AS 'NewFieldName' FROM Table1

Hope that this helps.
Steve

 

[mrdenny]

You use sp_rename to rename a column.

EXECUTE sp_rename N'dbo.table.column', N'new_column', 'COLUMN'

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLSister]

Just remember if you change a column name all the code which refernces this column will need to change.

Questions about posting. See faq183-874