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


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

Original text of this message