db2 -x "select 'drop table '||tabschema||'.'||tabname||';'from syscat.tables where tabschema ='ZHX'" > drop.sql db2 -tf drop.sql 转载于:https://www.cnblogs.com/coonver/p/5198561.html