Here's a quick example solution that may work depending on the data size, processing frequency, etc. (Temporary tables used here for example dataset processing)

IF OBJECT_ID('tempdb..#Maintable') IS NULL
BEGIN
--DROP...