Sponsor of the Day:
Jerkmate
https://www.jooq.org/doc/3.21/manual/sql-building/ddl-statements/drop-statement/drop-index-statement/drop-index-if-exists/
The IF EXISTS clause of the DROP INDEX statement
The IF EXISTS clause of the DROP INDEX statement is used to drop an index only if it already exists in the database.
exists clausedrop indexstatement
https://www.jooq.org/doc/3.21/manual/sql-building/ddl-statements/drop-statement/drop-function-statement/drop-function-if-exists/
The IF EXISTS clause of the DROP FUNCTION statement
The IF EXISTS clause of the DROP FUNCTION statement is used to drop a function only if it already exists in the database.
exists clausedropfunctionstatement
https://www.jooq.org/doc/3.21/manual/sql-building/ddl-statements/drop-statement/drop-synonym-statement/drop-synonym-if-exists/
The IF EXISTS clause of the DROP SYNONYM statement
The IF EXISTS clause of the DROP SYNONYM statement is used to drop a synonym only if it already exists in the database.
exists clausedropsynonymstatement