CODEWITHSUNDEEP
liquibase
Girish
Girish

Reputation: 1717

Liquibase DropAll DBobjects

How to drop ALL DB objects made using liquibase i have come accross the command DropAll, it only drop all tables in the database, i have explore on the google but still strugling, 

so i have drop the queue tables by running plsql with liquibase
then I have use the command dropAll to drop all the tables and sequences.

Is there is another solution to do that or I will stay with that

Upvotes: 1

Views: 6344

Answers (1)

Nathan Voxland
Nathan Voxland

Reputation: 15763

The dropAll command doesn't read the changelog and do a rollback, it snapshots the database and drops everything it sees. Unfortunately, it doesn't know how to snapshot and drop queues so they are not dropped.

Depending on the database, you may be able to just call "drop database X; create database X" to clear it out without using dropAll.

You can write an extension to build queue support into Liquibase (liquibase.org/extensions). You would need to create new classes to implement AbstractDatabaseObject, JdbcSnapshotGenerator, and UnexpectedObjectChangeGenerator that to add the support.

Upvotes: 1

Related Questions