Timeline for How to remove temp tables from SQL Server?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 6, 2018 at 16:58 | vote | accept | T.H. | ||
| Nov 6, 2018 at 16:47 | comment | added | T.H. | I have made multiple temp tables and I am manipulating them at the end to create a permanent table. Removing them earlier in the script will not allow me to use them at the end. Also, I was experimenting a lot with the query so I kept modifying the temp table names and so I have ended up with temp tables whose name I don't even remember. That's why I am looking to find a solution like clear console which allows to remove them completely and run my script with the correct names. | |
| Nov 6, 2018 at 16:41 | answer | added | S3S | timeline score: 5 | |
| Nov 6, 2018 at 16:40 | comment | added | LowlyDBA - John M | What is wrong with writing code to remove them? What have you tried that did not work? Have you read the docs on how temp tables work? | |
| Nov 6, 2018 at 16:39 | history | edited | LowlyDBA - John M |
Removing R2 tag
|
|
| Nov 6, 2018 at 16:32 | history | asked | T.H. | CC BY-SA 4.0 |