Associating Rollback Scripts with SQL Scripts

A best practice is to write a rollback script that undoes all changes made by the original script. 

Rollback scripts are included automatically in packaging if they follow a specified naming convention. 

To from the rollback script name, append -rollback (with a dash) OR _rollback (with an underscore) to the script name. 

Example script name:

AddMiddleNameColumnToAccountTable.sql

Rollback script name:

AddMiddleNameColumnToAccountTable-rollback.sql

or

AddMiddleNameColumnToAccountTable_rollback.sql