Hi All
I have developed an app using vb6 and sql server. App is now up and running at customer points.
I have added some more functionality in to the app for which i have added some more fields to the existing table and some new tables are also created.
Now I want to generate a query which if i run at customer system will change the structure of tables there without loosing the data.
And new tables must be created by the same query.
Is it possible to generate such query.If yes please let me know how?
Also how to run such query from vb6 app?
Please help
Thankx
Radhesham