Re: How to remove a column

> What's an easy way to remove a column from
> a table which already contains data?
>
> I'm using Oracle 7 Workgroup Server 7.3.2.2.1

You need to create a new table and then move the data into it from the original table. There is no way to drop a column directly. You can first rename the original table if you want the new one to have the same name. Ensure all constraints are dropped from the original and then applied to the new table. Received on Wed Aug 13 1997 - 00:00:00 CDT