Changing column name

I need to change a column's name say from col_ab to col_cd, what's the synta
x?
--
TSLook up sp_rename in Books Online.
"TS" <TS@.discussions.microsoft.com> wrote in message
news:1ED0D0AF-3D61-4C64-B296-28325F69959A@.microsoft.com...
>I need to change a column's name say from col_ab to col_cd, what's the
>syntax?
> --
> TS|||sp_rename '<table name>.<old column name>', '<new column name>', 'COLUMN'
"TS" wrote:

> I need to change a column's name say from col_ab to col_cd, what's the syn
tax?
> --
> TS