Timeline for How to remove temp tables from SQL Server?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 6, 2018 at 16:59 | comment | added | S3S |
You don't have to worry about that... once the session that created them is over, they will be dropped. If you are leaving all of your sessions open, then you have larger issues. More on temporary tables but you can list them all by looking in tempdb.sys.objects
|
|
| Nov 6, 2018 at 16:58 | vote | accept | T.H. | ||
| Nov 6, 2018 at 16:54 | comment | added | T.H. | Thanks for this. How do you think I can make sure that I have deleted all temp tables because I don't even remember some of the names? | |
| Nov 6, 2018 at 16:41 | history | answered | S3S | CC BY-SA 4.0 |