Drop all tables

[oana12]

Hi,
I want to create a script to drop every table which exist in my database. I know that in SQL Server, for example, you can create like this

if exists (SELECT * FROM sysobjects WHERE id = object_id('dbo.x') AND sysstat & 0xf = 3)
drop table dbo.x
GO

How can I do something like this in DB2 using sysstat.tables?

Thanks.

 

[Dagon]

Something like:

select 'drop table '||rtrim(creator)||'.'||rtrim(name)||';'
from sysibm.systables
where creator not in ('SYSIBM', 'SYSCAT')

 

[stevexff]

If you drop all the tables, there won't be much left. Why not just

DROP DATABASE my_db;

and re-create it afterwards?