Alter TABLE column name?

12 Aug 2005 12:04 PM

ReTF

Hi,
I need alter column name of a TRABLE and VIEW... HOw I do this? Thanks

12 Aug 2005 12:04 PM

Tibor Karaszi

sp_rename

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"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
>
>

12 Aug 2005 12:19 PM

Jens SÃ¼ÃŸmeyer

BOl is your friend:

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

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

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Show quote

"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@tk2msftngp13.phx.gbl...
> > Hi,
> > I need alter column name of a TRABLE and VIEW... HOw I do this? Thanks
> >
> >
>