Hi all,
i'm updating a new 'common management' software n i wanna update the database bcoz i added many extra tables.
i did write scripts for all the tables this way:

Create...........
Drop...........
Alter........

so our clients would be able to have access to it.
but i have been asked to write other ways script than using 'alter', becoz its like im having the database for the first time and our clients have the older version...
Any Ideas??

10x in advance

if you need to change the structure then you have to use ALTER.
you can create a different database from the existing ,make the changes and finally redirect the application to the new database.