Re: Column Drop

This whole drop column functionality is misleading (especially Microsoft's implementation in SQL Server 7).

I still think the temp-table-shuffle is best ( except, of course, a better design in the first place).

-Dean

On Wed, 21 Apr 1999 09:47:14 +0800, Andrew Babb <andrewb_at_mail.com> wrote:

>RC,
>
>You are not making sense but, with effect from Oracle8i (v8.1.5) you can
>logically drop the column from the table, but the space is not freed up
>for any existing data.
>
>Prior to Oracle8i, there was no way of doing this except for creating the
>table without the required column and then populating it using INSERT
>statements.
>
>Andrew
>
>RC wrote:
>
>> Can you drop a column from a table in Oracle 8 ? I know you can do it
>> in Oracle 8
>
Received on Sat Apr 24 1999 - 16:54:48 CDT