SQL Server Add Drop And Create For Rerunnable Scripts Setting
Published 15 January 2025
Description
When this option is selected, DROP
and CREATE
statements are used instead of ALTER
, and conditional DROP statements are added to CREATE statements, for the following objects:
- Views
- Stored Procedures
- Functions
- Extended Properties
- DDL Triggers
- DML Triggers
Note that if you select this option, the Add object existence checks option will automatically be selected, as this is required to make a functioning script.
Using this option may require additional database objects to also be dropped and recreated if those other objects depend on the selected objects; these operations will be added to the script automatically if dependencies are included.
Type
Boolean
Default
false
Usage
This setting can't be configured other than in a TOML configuration file.
Flyway Desktop
This can be set from the comparison options settings in SQL Server projects.
TOML Configuration File
[redgateCompare.sqlserver.options.behavior]
addDropAndCreateForRerunnableScripts = true