Personal tools
You are here: Home → DB2 → How To's → Dropping all tables from a specific schema
Navigation
Log in


Forgot your password?
 
Document Actions

Dropping all tables from a specific schema

Use this query to select and drop all tables of a schema


SCHEMA NAME = TEST

db2 -x "select 'drop table '||rtrim(tabschema)||'.'||rtrim(tabname) from syscat.tables where tabschema = 'TEST'"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls