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":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
08 December 2021

UID

ibm16340671