I would like to be able to drop temporary tables as soon as I am done
with them. Some research has revealed that temp tables are stored in the
tempdb database and SQL Server adds a numeric suffix to it. So if I call
the Tempdb.dbo.sysobjects table reveals that this table's full name is
All efforts to drop this table has failed. What is the syntax?
I have tried all of the following, with no success:
Does anyone have any ideas?
Thanks a lot,