Re: Renaming columns?
From: Slurton <slurton_at_aol.com>
Date: 24 Aug 1994 12:30:11 -0400
Message-ID: <33fsij$std_at_search01.news.aol.com>
Date: 24 Aug 1994 12:30:11 -0400
Message-ID: <33fsij$std_at_search01.news.aol.com>
In article <32tti5$dg2_at_freenet3.scri.fsu.edu>, howardh_at_freenet3.scri.fsu.edu (Howard Hartsfield) writes:
no there is not but do the following,
If you do not need to change any of the data type or add or subtract columns then:
- Use the Create temp_table as select col1, col2, col3, (new name for column), colN from (the current table);
- You will then have a temp table.
- drop the origanal table.
- use the rename command to rename the temp table to the original table.
Thats it
hope the table does not have to many columns in it.
Scott A. Lurton
Senior Analyst
WR SYSTEMS, LTD
FAIRFAX, VA
USA
Received on Wed Aug 24 1994 - 18:30:11 CEST