Re: Dropping a field from a table

Hello Colin,

I can offer you a workaround that will not drop the column but it may help you identify problems that you may find when really dropping the column.

1. "update ttt set ccc = null" will "empty" your column. Be careful about update triggers on ttt.
2. "alter table ttt modify (ccc null, constraint n_ccc_ttt check (ccc is null))" will prevent putting values in this column.

Martin

Colin Basterfield wrote:

> Hello,
>
> Perhaps a stupid question, but i can't find anywhere how to delete a
> field from a table. Is it possible?
>
> TIA
> Colin B
Received on Fri May 07 1999 - 20:58:12 CDT