DROP IF EXISTS

Each of the DROP statements supports an IF EXISTS clause. This allows the drop of an object to complete successfully, with no error being issued, if the object does not exist.

For example, to drop the EMPLOYEE table from WORKLIB, issue the following statement:

DROP TABLE IF EXISTS WORKLIB.EMPLOYEE;