Question

sql scripts

Scripts, SQL, SQL scripts

Hi all,
i'm updating a new 'commun 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

When writing change scripts you'll need to know what version of the schema the customer has. Once you do you can write the scripts to add in the new database objects. You'll need to use CREATE and ALTER commands to create the new objects and update the existing objects.