The liquibase documentation for dropView lists the attribute ifExists as supported by DB2. That is wrong.
DB2/LUW and DB2/z does not support IF EXISTS for DROP VIEW. Sources:
It is supported by IBM/i:
The liquibase documentation for dropView lists the attribute ifExists as supported by DB2. That is wrong.
DB2/LUW and DB2/z does not support IF EXISTS for DROP VIEW. Sources:
It is supported by IBM/i:
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Exists-preconditions, offline databases and generated SQL | 0 | 815 | May 6, 2015 | |
| Unable to <dropView> (view not found) | 3 | 1874 | March 24, 2019 | |
| Oracle Materialized views DROP | 2 | 1934 | April 12, 2013 | |
| Documentation bug for dropTable | 0 | 343 | September 16, 2014 | |
| dropView fails to find view and viewExists doesn't work on liquibase 4.32.0 | 9 | 256 | June 2, 2025 |