DB2 Drop table if exists equivalent

Question

I need to drop a DB2 table if it exists, or drop and ignore errors.

Answer 1

Try this one:

IF EXISTS (SELECT name FROM sysibm.systables WHERE name = 'tab_name') THEN
DROP TABLE tab_name;END IF;