How Change Column Name?
Date: 1997/12/04
Message-ID: <34873a20.0_at_news1.ibm.net>#1/1
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?
I do not know how to get the data back in if say I export the table.
and therefore will not import.
'filler' and 'seq_no' will be the same size so it is really just a
col.
name change. Is there a way to dump table data to a stream like file,
one row of comma separated after another so I can reinput it with
sql-loader
or what?
The col. has no foreign key ties or anything.
Thanks.
stantow_at_ibm.net Received on Thu Dec 04 1997 - 00:00:00 CET