Re: fix table. HOW TO?

You can "delete" columns by making another copy of you table without the "extra" columns:

create table new table as select col1, col2, col4,col8 from oldtable;

Of course you can add a where clause to select the rows you want to 'copy'.

After you create the table you can and constraints, drop old table, copy newtable to oldtable... Received on Wed Jul 07 1999 - 15:11:39 CDT