Re: ddl-sql: how to delete column from table

You must remember to re-create any indexes, constraints, triggers and synonyms as well though.

Incidentelly, I understand that alter table drop column works in 8i.

Alan

Mark wrote in message <37820338.5951437_at_newshost.us.oracle.com>...
>Pedro
>
>Oracle does not support this.
>
>You will have to create a copy of the table without the column you
>don't want.
>
>Mark
>
>
>On Tue, 6 Jul 1999 14:30:00 +0200, "Pedro Pablo Ramírez Estrela"
><pramirez_at_cev.es> wrote:
>
>>Hi,
>>could someone tell me how to delete a column from a table?
>>i've used the sql:
>>
>>"ALTER TABLE table_name DROP column_name"
>>
>>but it seems it doesn't work for Oracle.
>>
>>Thanks,
>>
>>Pedro.
>>
>>
>
Received on Tue Jul 06 1999 - 10:01:13 CDT