IBM Support

DROP support for IF EXISTS

News


Abstract

The optional IF EXISTS clause can be used to avoid an error if the object being dropped does not exist.

Content


drop if exists comparison

The IF EXISTS clause is supported on all DROP SQL object types.

See the SQL Reference for details: DROP

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;and future releases"}]

Document Information

Modified date:
26 March 2025

UID

ibm16340671