Re: Dropping a column?

John,

The only way to do it is create a new temporary table without that column (create table temp as (select col1, col2, etc from table)

then drop the other table and create it again from the temp table. Once the column is there, it's there to stay.

Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com Received on Fri Jun 13 1997 - 00:00:00 CDT