Drop the table and recreate it is the only method I know of. To preserve
the data make a backup table: create table <tab_bu>.. as select * from
<table_nm>; and make a list and copies of any grants, triggers,and indexes
you have on the table before you drop it; they will needed to be recreated.
Then check for procedures, functions, and packages that may have had their
status set to invalid -- ie need recompiling -- after the table is dropped.
What a pain!!! Does anyone have a script to handle all this?
bg
Margaret Ngai <margaret_at_synrevoice.com> wrote in article
<01bc9e91$fb919580$aa57f8ce_at_laputa>...
> 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
>
Received on Sat Aug 02 1997 - 00:00:00 CDT
