renaming column at run time [message #288543] |
Mon, 17 December 2007 23:58  |
hidnana
Messages: 87 Registered: November 2007 Location: chennai
|
Member |
|
|
Is it possible to do something like this from a running program ?
alter table xxx rename column c1 to c2;
I'm unable to try this out as I don't have the privilege.
|
|
|
|
|
|
Re: renaming column at run time [message #288561 is a reply to message #288559] |
Tue, 18 December 2007 00:40   |
dhananjay
Messages: 635 Registered: March 2002 Location: Mumbai
|
Senior Member |
|
|
Quote: | Michel Cadot
Quote:
but, why do you want to do that????
Because there is only one table and each program renames the table and its columns for its needs.
|
i didn't quite understand ?
regards,
|
|
|
|
|
Re: renaming column at run time [message #288726 is a reply to message #288543] |
Tue, 18 December 2007 07:46  |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
Why do you want to actually rename the columns? what use is this? But if you must here are 3 selects with different names for the columns
select col1,col2,col3 from my_table;
select col1 cola, col2 colb, col3 colc from my_table;
select col1 this, col2 is, col3 stupid from my_table;
Hows this?
Or even
create view my_table_v
as select col1 this, col2 is, col3 stupid from my_table;
[Updated on: Tue, 18 December 2007 07:47] Report message to a moderator
|
|
|