SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

 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


Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.


Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...