SQL/VBscript - Modifying Design of Tables from within ASP page
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables. I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript???
sorry for the longwinded approach!
Any help would be much appreaciated.
thanks - i don't have enterprise manager installed. it's too big to download!! thanks for ther help