#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    29
    Rep Power
    0

    SQL/VBscript - Modifying Design of Tables from within ASP page


    hi all,
    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
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    29
    Rep Power
    0
    thanks - i don't have enterprise manager installed. it's too big to download!! thanks for ther help

IMN logo majestic logo threadwatch logo seochat tools logo