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
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