where's ALTER TABLE table DROP [ COLUMN ] column???

Hello!

just trying to write an upgrade script for my bookkeeping system.... and
noticed that it seems that i can't throw out the legacy stuff
accumulated over time.... 

as far as i can tell, i can add columns to a table, but can't remove
them later on.....


is this true? any easy way to circumvent this inside the DB, without
destroying the existing tables (the problem: make backup f the existing
table, without the offending column, drop the table, recreate it, feed
it with the backup) if someone has any solution for this, i am taker!


-- 
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....