Re: Dropping columns in 8.04? Or 8.15 ie 8i?

Hey,
try something like this

create table temp as select field1,field2 from table1;

drop table1;

create table table1 as select * from temp;

Olli

Acorn schrieb in Nachricht ...
>Does anyone know if 8.04 allows 'alter table drop column', I only see 8i
>allowing this. Has anyone else run into this problem?
>
>Thanks in advance!
>Conrad
>
>
Received on Thu Apr 22 1999 - 02:00:53 CDT