Re: Delete column(s) from a table

On Tue, 6 May 1997 23:40:57 +0800, "Patrick C. K. Wu" <ckwu6_at_iesun21> 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
>

The way to delete a column from a table is to create a new table without the column name in it using a select statement with every column referenced but the unwanted column, drop the old table, then rename the new table to the old. Rather laborious, but this is ANSI standard....

PS, (I know duh....) but, be sure to export the original table out before doing anything like this!

sheilah scheurich
dba
>
Received on Wed May 07 1997 - 00:00:00 CDT