Except for SQL Server, which doesn't allow column modification of any
kind without dropping the table.
Jonathan Gennick wrote:
>
> On 10 Apr 1998 07:44:40 GMT, "Steven Cools"
> <Steven_at_digimap.be> wrote:
>
> > this is a very simple question : how can I delete a column from a table
> >definition using PL/SQL? I searched through the manual of PL/SQL but I
> >couldn't find it. Why is it not as simple as in Informix/SQL:
> >
> >alter table TABLENAME
> >drop NAME-OF-COLUMN
>
> I think Oracle is the only database on the face of the earth
> that can't handle this<g>. There is no "DROP COLUMN"
> command. You have to save the data, drop the table, recreate
> the table, reload the data, and recreate all constraints &
> indexes in order to remove the column.
>
> regards,
>
> Jonathan
Received on Mon Apr 13 1998 - 16:58:27 CDT
