Re: tables and columns

alter table ... drop column ...;
or
alter table ... drop (<list of columns>); is only available in Oracle8i not earlier.

--
Michel

Leif Kuschel <Leif.Kuschel_at_t-online.de> a écrit dans le message : 87rhm7$f04l$1_at_fu-berlin.de...
> thanks for answer,
>
> I think the most of my problems are solved with a special oracle - sql -
> manual :-).
> Is there any webside ?
>
> At this moment I checked the sql - command :
> "ALTER TABLE TeSiPrivilege DROP COLUMN columnname;"
> But it doesn't work.
> SQL *Plus give me the error message : "keyword missed" with a star by
> COLUMN.
> In my SQL-manual I found the following definition of ALTER:
>
> ALTER TABLE table {ADD {COLUMN field type [(size)] [NOT NULL] [CONSTRAINT
> index] |
> CONSTRAINT multifieldindex} |
> DROP {COLUMN field I CONSTRAINT indexname} }
>
> Is it not true ?
>
> thanks , Leif
>
>
>
>
Received on Wed Feb 09 2000 - 05:34:38 CST