Temporary tables will be deleted automatically when the connection that was using them is disconnected. If there are normal tables those will be deleted automatically when the SQL Server instance is restarted.
Register Hereor login if you are already a member
Discuss This Question: