Re: Delete column(s) from a table

From: Hakan Eren <sarisin_at_interlog.com>
Date: 1997/05/23
Message-ID: <3385D51F.626B@interlog.com>#1/1

Patrick C. K. Wu wrote:
>
> Hi all
>
> Could anyone tell me how to delete column(s) from a table using SQL
> statement?
>
> Thanks for any pointers and comments
>
> Regrads/Patrick C. K. Wu
> email: ckwu6_at_ie.cuhk.hk

You cannot delete any column to a table. But you can add by ALTER command.

Tou shoul drop and re-create the table.

You can use desc <table_name> and edit spool file (use spool before that. So, you are not required to write all column names and definitions.) Received on Fri May 23 1997 - 00:00:00 CDT