Question :- In which database temporary tables are created in SQL Server?
1) User database (where temporary table are defined)
2) Master database
3) TempDB (Correct Answer)
1) User database (where temporary table are defined)
2) Master database
3) TempDB (Correct Answer)
4) Model Database
5) None of the above
Answer
Thanks to all who attempted this question. 84% people gives the correct answer:-)
Correct answer is option 3, TempDB. All the temporary tables and table variables are created in the TempDB.
Related Articles
SQL Server - Local temporary table
SQL Server - Global temporary tables
