Drop MySQL table using Liquibase

user_3076981 0
Viewed 17539

I am looking to drop a table in MySQL using Liquibase only if the table exists.

I am not able to figure out how to check if a table exists in Liquibase.

liquibase drop-table mysql database java
3 Answers

Below is the Groovy version of dropping the table with Liquibase using preConditions chack that the table exists.

changeSet(author: "author", id: "some_id_value") {
    preConditions(onFail: "MARK_RAN"){
        tableExists(tableName: "table_name")
    }

    dropTable(tableName: "table_name")
}
user_7868180

Here is a YAML snippet for dropping a table if exists

- changeSet:
    id: drop-my-table-if-exists
    author: the-author
    comment: drop my_table if exists
    preConditions:
    - onFail: MARK_RAN
    - tableExists:
        tableName: my_table
    changes:
    - dropTable:
        tableName: my_table
user_81529180
Related