(no subject)

  To drop a column:

create table 'tablename' as select col1, col2... from the original table, selecting only the columns you wish to keep.

You will also need to recreate any table constraints and indexes.

This approach seems a little inelegant, hopefully someone might have a better suggestion.

Justin Lane
Information Architect
Eli Lilly Australia Received on Wed Jan 17 1996 - 01:34:28 CST