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 ============================================================== [EMAIL PROTECTED] 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.... ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly