Daniel Morgan wrote:
> Excuse me ... but ...
>
> SQL> create table xyz (
> 2 firstfld varchar2(2),
> 3 secondfld varchar2(2),
> 4 lastfld varchar2(2));
>
> Table created.
>
> SQL> alter table xyz
> 2 drop column secondfld;
>
> Table altered.
>
> SQL>
>
> You can drop any column you want in 8.1.7. and above.
>
> Daniel Morgan
>
Oops. You are absolutely right. I thought I had tried this in the past
and it failed. Must be I'm getting old ... sad, but true. Thanks for the
correction, Daniel.
Received on Thu Oct 24 2002 - 15:15:20 CDT
