sometimes you come into a situation where you have to drop all tables in a given schema. The easiest way is to delete the user and recreate him again but when lacking system privileges you will look for another way. I’ll find the following very handy and will delete all specified db objects…. BEGIN FOR…