Here I show you how to truncate a mass of tables in the same schema. Of course, you don't have to limit it to a single schema if you don't want.