0 - 1 of 1 tags for drop multiple

Hello, I am looking to write a stored procedure that when I execute, will drop tables under a certain condition. The reason for this is to drop the temporary tables that SAP leaves behind when a job fails. Purely a testing environment proc, not meant for the customer.