Jeff Moden (9/22/2016)
I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View that we created to get around some colossal fubar built by my predecessors that needed to be fixed without changing a mountain of code.
In this particular case, I wrote the code that created the tables and they were just being used in case we needed to rerun a process during the day. It's just that I didn't think things through a few years ago when I initially did the backup part of this proc and forgot to use a check to verify there were records to backup before creating the table.
So the only thing depending on the tables was this one proc. Therefore, there was no trouble to be gotten into for cleaning up after myself.