Re: How to drop column in a table

From: Subbu <skorisapati_at_worldbank.org>
Date: 1996/02/23
Message-ID: <4gkjv7$a4h_at_minerva.worldbank.org>#1/1


Consider ur original table (org_table_name) has 7 columns (col1,col2,col3... col7)

rename org_table_name to old_table_name;

Create table org_table_name as
select col1, col3, col5, col7
from old_table_name;

drop table old_table_name;

Dont forget grants / creating other indexes. Received on Fri Feb 23 1996 - 00:00:00 CET

Original text of this message