Re: Help! How to delete a column?

Margaret Ngai wrote:

> I have added a column which I don't really want in a table. How can I
>
> delete it?
>
> ALTER TABLE does not support the DELETE function & Schema Manager
> doesn't
> have a remove option for a column.
>
> Any suggestions is welcome. Thanks.
>
> --
> Margaret Ngai
> E-Mail: margaret_at_synrevoice.com

There is currently no method for removing a column. The only workaround that can be done is to rename the table and the issue a CREATE TABLE. . . AS SELECT. . . and not specify the missing column in the SELECT clause.

--
====================================================================
Byron Pearce                         mailto:bpearce_at_csac.com
Systems Consultant                   http://www.csac.com
Computer Systems Authority (CSA)     Dallas, Texas

"It's hard to be a ninja when you wear a beeper."