How to manage database modifications ("ALTER TABLE")
Posted: Tue Nov 04, 2008 6:25 pm
Hi all,
I am developing a module which also uses databases.
During the development of the new subrelease, I noticed, that I want to add a database field to a table. So, how can I use the update-process of a module to insert a new database field?
I know, there is the default function "Install()" which can be used for creating tables (using ADODB), but is there also an "Update()"-function where I can use "ALTER TABLE" - commands?
br and thanks in advance
Michael
I am developing a module which also uses databases.
During the development of the new subrelease, I noticed, that I want to add a database field to a table. So, how can I use the update-process of a module to insert a new database field?
I know, there is the default function "Install()" which can be used for creating tables (using ADODB), but is there also an "Update()"-function where I can use "ALTER TABLE" - commands?
br and thanks in advance
Michael