Dropping objects before create

bpye

Is there any way to generate a package that will check for existence of database objects and drop them if they exist, before creating them?

Brian Donahue

Hi,

Unfortunately not. New database packages shouldn't need this logic, and upgrade packages attempt to modify and adjust existing objects.

bpye

Thanks for the reply. Will any of the Red Gate tools generate IF EXISTS...DROP... scripts for objects I select?

bpye

In case anyone is interested, I ended up generating DROP script by configuring SQL Packager to upgrade to an empty database.