Hi @lonetiger You can do it by two kind of scripts: 1- show all tables: SHOW TABLES; get the list and run this query on all tables: DESCRIBE FORMATTED tableX; Then you can get the results and extract the owner, if it's the desired one, drop the table. 2- Connect with your hive metastore DB and get the table list of the owner you want SELECT "TBL_NAME" FROM "TBLS" WHERE "OWNER" = 'ownerX'; Then drop them. Good luck. ... View more