Re: alter tabel ddl statement drop column

From: <ngroves_at_ndsuk.com>
Date: Fri, 28 May 1999 16:33:13 GMT
Message-ID: <7imgg9$pod$1@nnrp1.deja.com>

In article <374EAD51.4D249745_at_charlestoncounty.org>, Peter Shankey <shankeyp_at_charlestoncounty.org> wrote:
> What is the reasoning as to why a alter table command does not let a
> column be dropped?? What is the accepted method for removing a column
> from a table?
>
> thanks
>
>

I've got a document from oracle that lists this as enhancement request 51118.

either a) set the column to be null, rename the table then create a view on the renamed table
b)create a new table as select specific columns from old table   drop old table
  rename new table to old table
  recreate indexes, grants etc

regards
nigel groves

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 11:33:13 CDT