SQL Server - Table Column Name Change

[doog]

Is there a way to change a table column name in SQL server using SQL not the enterprise manager?

[degsy]

Try this SQL code

ALTER TABLE `tablename` RENAME `newname` ;

[doog]

Is there a way to change the column name, not the table name?

[degsy]

you mean you want to change the field name?

You will have to work with the current info, but it should be something like

ALTER TABLE `tablename` CHANGE `fieldname` `newfieldname` INT( 25 ) NOT NULL AUTO_INCREMENT

Where
INT( 25 ) NOT NULL AUTO_INCREMENT
are the attributes of the filed.

[doog]

Tried: ALTER TABLE MFN_EQ_RET_Combined_2_1_2005 CHANGE[service type] [service type_superseded] VARCHAR( 100 )

And this does not work. CHANGE is not a reserve work in SQL SERVER... Any other guesses?

[degsy]

sorry, they are the commands I use with mySQL database.
Thought they may work with SQL Server aswell.

[doog]

Thanks- I'm also a mySQL programmer and perfer it to

[z1p]

doog, don't know if you are still looking, but here is the online reference for sqlserver SQL. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp)

It looks like you are out of luck. Your only choice may be to add a new column, move the values over and delete the old column. Not pretty, but would serve the purpose.