[Zope] ZSQL question

I have a table with lots of data in my Gadfly database. I would like to add a couple of new columns to that table. Is it at all possible to add columns to existing table or do I have to create a new table all together? Regards, George ___ Zope

Re: [Zope] ZSQL question

I have a table with lots of data in my Gadfly database. I would like to add a couple of new columns to that table. Is it at all possible to add columns to existing table or do I have to create a new table all together? Nope, ALTER TABLE TABLE_NAME ADD COLUMN_NAME FORMAT_TYPE i think should