Re: Drop Columns

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