In the Schema Browser, when creating a script, it always includes a Drop statement. How can the script get created without a Drop statement?
In the Schema Browser's Script tab, there is a toolbar. The first icon in the toolbar is View\Edit Script Options. Click that icon and un-check the Drop Statement option.
The option can also be found by right clicking on a table in the Schema Browser and selecting Create Script. There is a Script Options tab with the same Drop Statement option.
Un-checking the Drop Statement, in either of these windows, will stop the Drop statement from being created in any future scripts.