|
Home > Archive > MS SQL Server > October 2006 > how to modify column names through TSql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to modify column names through TSql
|
|
|
| Hi,
I need to just change the case of some letters in a column of a table,
e.g. from PURCHASE_ORDER to Purchase_Order and I can do it easily through
EM.
Works well and preserves all the data in tact.
Is it possible to do the same through a query, or some script so that an end
user won't go to EM and do this manually but rather could run a script.
Essentially I am looking for some command like
alter table AAAA alter column PURCHASE_ORDER [to new column name
Purchase_Order] or something like that.
Thank you
Vadim
| |
| Hilary Cotter 2006-10-24, 6:37 pm |
| http://databases.aspfaq.com/databas...e-a-column.html
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Vadim" <vadim@dontsend.com> wrote in message
news:OK2XSJy7GHA.4568@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I need to just change the case of some letters in a column of a table,
> e.g. from PURCHASE_ORDER to Purchase_Order and I can do it easily through
> EM.
> Works well and preserves all the data in tact.
>
> Is it possible to do the same through a query, or some script so that an
> end user won't go to EM and do this manually but rather could run a
> script.
>
> Essentially I am looking for some command like
>
> alter table AAAA alter column PURCHASE_ORDER [to new column name
> Purchase_Order] or something like that.
>
> Thank you
>
> Vadim
>
| |
|
| Thank you very much, I'll try this.
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:e3Ts2ty7GHA.3740@TK2MSFTNGP05.phx.gbl...
> http://databases.aspfaq.com/databas...e-a-column.html
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Vadim" <vadim@dontsend.com> wrote in message
> news:OK2XSJy7GHA.4568@TK2MSFTNGP02.phx.gbl...
>
>
|
|
|
|
|