Thanks. I did manage to make a Column() that was no longer associated with a table. The append_table() code ran fine then, but the database did not actually change. I bound it to the correct engine and metadata (so I think) but no luck.
I also started down the ALTER TABLE path earlier, and in fact am doing that for deleting columns but for adding a column I need to extarct the type, Integer, Varchar(32), etc. out of my Column(), correct? My small brain is probably missing something, but that seemed a bit more difficult. Thanks again. - Nelson On Aug 11, 3:47 pm, "Michael Bayer" <[email protected]> wrote: > 1. append_column() only raises that error if the Column() you're sticking > there was already associated with some other table or selectable object. > > 2. you need ALTER TABLE. you can of course just say engine.execute("ALTER > TABLE <rest of statement>"). For more options, there is an FAQ entry > here: > > http://www.sqlalchemy.org/trac/wiki/FAQ#DoesSQLAlchemysupportALTERTAB... > > > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
