Which statements have automatic rollback?

General Discussion
1

Hi all,

Is there a comprehensive list of which modifications do and do not allow automatic rollback?

I recently used the rollback functionality for the first time on a live system, and am now writing up guidelines of how to repeat the procedure. The documentation mentions that some changes don’t need an explicit rollback action set, but it would be good to have a complete list so I can guarantee the rollbackability (!) of our system.

We’ve been using LiquiBase for a few months now, and I don’t know how I ever managed without it.

2

Thanks!

3

Based on searching the code for implementations of the createInverses() method yields the following list of changes that would appear to support automatic rollback.   (Nathan can correct this if I am wrong…)

AddColumn
AddDefaultValue
AddForeignKeyConstraint
AddLookupTable
AddNotNullConstraint
AddPrimaryKey
AddUniqueConstraint
CreateIndex
CreateSequence
CreateTable
CreateView
DropNotNullConstraint
RenameColumn
RenameTable
RenameView
TagDatabase