DROP TABLE Experimental_parameters IF @@ERROR <> 0 BEGIN --DO SOMETHING HERE (i.e. RAISERROR & RETURN) END #### if (SELECT COUNT(*) FROM #Experimental_parameters) <> 0 begin DROP TABLE Experimental_parameters end