DB2 equivalent for mysql's DROP TABLE IF EXISTS

onemanifest · #1 (**permalink**) 09-28-06, 02:20

Hi,

I'd wonder if there's a way to do something like mysql's

Code:

DROP TABLE IF EXISTS <tablename>

in DB2?

Peter

rahul_s80 · #2 (**permalink**) 09-28-06, 02:29

hi Peter

Use the db2perf_quiet_drop procedure. The source code is available on
ftp://ftp.software.ibm.com/ps/produc...perf-1.0.1.zip
In the file db2perf_utils.db2 there is the procedure db2perf_quiet_drop
which suppresses the 'not found' message.
The call :
CALL db2perf_quiet_drop( 'procedure db2perf_crmsg' )@
drops the procedure db2perf_crmsg if this procedure exists

regards,
Rahul Singh

Internet Services

Web Development

Digital Marketing

Consumer Tech