17 Oct
2000
17 Oct
'00
3:39 p.m.
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 do it... Let me check ALTER TABLE memberlist ADD name VARCHAR Yep... that does it. Although I had tested this in PGSQL, Im sure it works for GadFly also. Since you are also inserting a new column you may want to initialize all current reocrds with a value, but I cant remember what it was... If you really need it, let me know, I'll dig in for you. Cheers, -- Paz Oratrix Development BV http://www.oratrix.com GRiNS SMIL Editor -