>Can I remove this column or will I need to drop the entire table and restore from backup?
There's not a "remove column" option for alter table, but you may be able to get around restoring by renaming the existing table, creating a replacement the way you want it to look, & then copy from the old to new using "insert into table newtable (col1,col2) values (select col1,col2 from oldtable);" -Nick -------------------------------------------------------------------------- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])