Re: How Change Column Name?
From: Mark R. Aughenbaugh <marka_at_erudite.com>
Date: 1997/12/04
Message-ID: <34873dce.0_at_news3.uswest.net>#1/1
Date: 1997/12/04
Message-ID: <34873dce.0_at_news3.uswest.net>#1/1
Try using the 'create table table_name as select ...' statement. Example found in the Oracle7 Server SQL Reference manual, pg. 4-387. Then rename the new table back to the original name.
Stan Towianski wrote in message <34873a20.0_at_news1.ibm.net>...
>Hi,
>
>I have a table that has a column named 'filler' that was not used
>and I want to use it now and rename it to 'seq_no'.
>What is the best way to do this?
>
>
Received on Thu Dec 04 1997 - 00:00:00 CET