Re: How can I drop a column from a table?
From: ARAMSTER <aramster_at_aol.com>
Date: 1996/07/31
Message-ID: <4tojda$ajd_at_newsbf02.news.aol.com>#1/1
Date: 1996/07/31
Message-ID: <4tojda$ajd_at_newsbf02.news.aol.com>#1/1
The only way I know of is to create another table with that column
dropped, then in SQL*Plus use
insert into new_table
select col1,col2,col3 ---etc (leaving out the column you want to delete)
from old_table
Then you could rename old_table to tmp_table
and rename new_table to old_table.
Don't drop the tmp_table until you verify all the data got copied.
Received on Wed Jul 31 1996 - 00:00:00 CEST