Change coloum name

[lordfa9]

I need to change the column name of one of my tables for example

ItemID		  ItemName1					  Coffee

changed to

StockID		  StockName1					  Coffee

i need an SQL statement to do that, i want the name to be changed (instead of using an AS command)I was also reading something about using the ALTER TABLE and ALTER COLUMN commands, are these the correct command(s) to use and if so, how do i use them in a statement?

[aspnetguy]

ALTER TABLE tableName CHANGE ItemID StockID

try that