Alter TABLE column name?

Hi,
I need alter column name of a TRABLE and VIEW... HOw I do this? Thankssp_rename
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ReTF" <re.tf@.newsgroup.nospam> wrote in message news:unTHkVznFHA.1048@.tk2msftngp13.phx.gbl
..
> Hi,
> I need alter column name of a TRABLE and VIEW... HOw I do this? Thanks
>|||BOl is your friend:
B. Rename a column
This example renames the contact title column in the customers table to titl
e.
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Tibor Karaszi" wrote:

> sp_rename
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ReTF" <re.tf@.newsgroup.nospam> wrote in message news:unTHkVznFHA.1048@.tk2
msftngp13.phx.gbl...
>