Changing a column name (MS SQL 2000)

How can you change a Column name for MS SQL 2000 ?

something like :

ALTER TABLE [dbo].[MyTable]
OldName RENAME NewName
GO

thank you

EXEC sp_rename 'Tablename.[oldColumn]','NewColumn','COLUMN'


Thanks

R.A.F

with ' ?

'COLUMN' looks strange but I try

thank you

That's the syntax, tells sql you want to rename column. You can use it to rename other kinds of object as well.

I keep it somewhere :) thank you