> Somehow some columns from one of my tables "melded" with another table. > I'm trying to figure out how this happened, but in the meantime, I'd > like to be able to delete the extra columns in the table. > > I can see a way to "alter table ... add column". Is there a way to > "alter table ... drop column"?
SELECT without_a_column INTO xxx FROM tab; DROP TABLE tab; ALTER TABLE xxx RENAME TO tab;