ALTER TABLE my_table
ADD my_new_column INTEGER
This statement will add a new column called "my_new_column" containing integer data to the table "my_table".
And you can also add constraints such as NOT NULL if desired. However your ability to execute this statement from LV
will be dependent upon the permissions that have been granted to your account has been granted.
I have a similar requirement. Could you please post an example VI to add new columns programmatically.
I believe it should look something like this:
This would add a column called newField of type Text into the myNewTestTable table. As Mike noted, you will need permissions to modify the database though.