Is there any db2 command equivalent to mysql's DROP TABLE IF EXISTS

Cheers

No, that syntax is not supported. However, you can just drop the table and intercept the return code that DB2 returns if the table does not exist.

I found a solution but I am not sure it's safe to do or not.

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

cheers
Melb

Keep in mind that you also need the TABSCHEMA column to uniquely qualify a row in the SYSCAT.TABLES. Also, not all entries in SYSCAT.TABLES are base tables (some are views, nicknames, etc), so use the TYPE column if that matters to you.

use case .. when statement , to drop table , if exists.


sample as below



select case when exist ( select 'X' from sysibm.systables where name 'PSLOCK' ) then ' drop table '||name else ' ' end from sysibm.systables where name = 'PSLOCK' and type = 'T'


Thank You


Lekharaju Ennam