thanks for your response carp!
when you say: bad_name1 good_name1, bad_name2 good_name2,.....,bad_name_n good_name_n from old table
please what do you mean?
do you mean create new_table as select col1..coln from old table?
I don't want to assume so I wait for your invaluable response.
I have a table that I am trying to restructure.
This table was designed 15 years ago and is not very discriptive.
I need to do three things:
One, create a new table with column_names that are descriptive,
Two, move the data from the old table over to new table and
Three, clean the data up since...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.