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

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 - 08:24:10 CDT