Answer – Objective Question (In which database temporary tables are created in SQL Server)

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)

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