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 to the script name.
Example script name:
AddMiddleNameColumnToAccountTable.sql
Rollback script name:
AddMiddleNameColumnToAccountTable-rollback.sql