Re: Drop Columns
Date: 1996/09/08
Message-ID: <3232C801.5F47_at_charlie.acc.iit.edu>#1/1
Phoenix Business Enterprises wrote:
>
> I've got a table with data in it.
>
> Short of dropping the table, recreating, temp table to hold data bla blabla abl
>
> Is there an easy way to drop a column from a table that contains data? If not,
> any utils? Stored procedures?
>
> _
> NOTE: This software is currently in early alpha. If you notice any
> problems, or RFC non-compliance, please report it to pbe_at_pbe.com
> \------------------------------------------------------------\
> \ Chad Z. Hower - phoenix_at_pobox.com \
> \ Phoenix Business Enterprises - pbe_at_pbe.com - www.pbe.com \
> \ Physically in Church Hill, TN - Logically Not Sure \
> \------------------------------------------------------------\
> >>SQUID - The ultimate 95/NT offline databasing reader
> **Special Compile: 3.000A (Alpha)
I don't think you can drop column directly from the table. The only way is create a temp table without this column and drop the original table and rename the temp table to a original table.
AMARENDRA B NETTEM
-- AMARENDRA B NETTEM PH.No. (312)945-2116 HOMEPAGE: http://www.iit.edu/~nettama E-MAIL : nettama_at_charlie.acc.iit.eduReceived on Sun Sep 08 1996 - 00:00:00 CEST