Re: Deleting Fields

As far as I know:
You can't delete a field. you hav to create yourself a new table based upon your original table:

create table newtable as select column1, column2 , column3,column5 from orgtable;

and then :

rename orgtable to newtable.

Remember to put storage parameters
(if needed )
Anthony D'Cruze <anthony_at_tamesystems.com> wrote in article <364713c9.0_at_195.182.170.1>...
> I am working on a system where I have a developer database and whenever I
> make changes to the database I send the *.SQL file to the administrator
of
> the live one.
>
> What I need to do is to delete a field from a table.
>
> Can any one help with the SQL.
>
>
>
>
>
Received on Mon Nov 09 1998 - 14:14:00 CST