How to drop all tables and Views from a specific schema
dropping all tables and views from a specific SCHEMA, SYSPROC.ADMIN_DROP_SCHEMA
Dropping all tables, views and the own schema:
CALL SYSPROC.ADMIN_DROP_SCHEMA('SCHNAME', NULL, 'ERRORSCHEMA', 'ERRORTABLE')
Replace 'SCHNAME' to schema name, example for DEPT schema :
CALL SYSPROC.ADMIN_DROP_SCHEMA('DEPT', NULL, 'ERRORSCHEMA', 'ERRORTABLE');
Dropping all tables
db2 -x "select 'drop table ' || rtrim(tabschema) || '.' || rtrim(tabname) || ' '
|| ';'from syscat.tables where type = 'T' and tabschema='<schema_name>'"
Dropping all Views
db2 -x "select 'drop table ' || rtrim(tabschema) || '.' || rtrim(tabname) || ' '
|| ';'from syscat.tables where type = 'V' and
tabschema='<schema_name>'"
Dropping all Views and all Tables
db2 -x "select 'drop table ' || rtrim(tabschema) || '.' ||
rtrim(tabname) || ' ' || ';'from syscat.tables where tabschema='<schema_name>'"