sp_rename 'tablename.oldcolumnname','newcolumnname'

ALTER TABLE table_name
 RENAME COLUMN old_name to new_name;

hi all

sp_rename 'tablename.oldcolumnname','newcolumnname','column'

hi frnds, tell me one thing what is the difference b/w AS 
keyword & sp_rename,AS is also used for reanme operation na.

ALTER TABLE table_name
 RENAME COLUMN old_name to new_name;

This example renames the contact title column in the 
customers table to title.

EXEC sp_rename 'customers.[contact 
title]', 'title', 'COLUMN'

Sonia, clear your doubt here.

AS keyword is used for aliasing some existing column name 
for our convenience.But the column name doesn't change @ 
database.

But incase of renaming a column the change is reflected @ 
database n it's usually done if we wish changing property 
of a particular column.

sp_rename 'tablename.oldcolumnname','newcolumnname'->This 
actually works out for Sql 2000.ALTER TABLE key doesn't 
help.