Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Where Do Temporary Tables Get stored in sql server?

Tags:

sql

sql-server-2005

temp-tables

Where do temporary tables get stored in a database? I want to drop a temporary table if it already exists. I can do this for securable tables by querying at information schema but I don't know where temporary tables are stored.

like image 751
Shantanu Gupta Avatar asked Jun 10 '10 08:06

Shantanu Gupta

People also ask

Are temp tables stored in memory?

This all means that temporary tables behave like any other sort of base table in that they are logged, and stored just like them. In practice, temporary tables are likely to remain cached in memory, but only if they are frequently-used: same as with a base table.

How does SQL Server store temp data?

To create a Global Temporary Table, add the “##” symbol before the table name. Global Temporary Tables are visible to all connections and Dropped when the last connection referencing the table is closed. Global Table Name must have an Unique Table Name.

2 Answers

Temporary tables are stored in tempdb Database. There are various ways to check if a temp table exists outlined here: Check If Temporary Table Exists.

like image 141
Giorgi Avatar answered Sep 18 '22 15:09

Giorgi

Temporary tables gets stored in tempdb database which is present in SystemDatabase or SystemDatabase -> tempdb -> Temporary Tables

like image 37
Ankit Chaurasia Avatar answered Sep 18 '22 15:09

Ankit Chaurasia
Sign in to Comment

Related questions

EF6 CodeFirst My [Key] Id Column is not auto-incrementing as an identity column should
Change the order by when selecting "edit top 'N' rows"
Chaining JSON_EXTRACT with CAST or STR_TO_DATE fails
check if clob contains string oracle
Is there any reason for numeric rather than int in T-SQL?
What's the best to check if item exist or not: Select Count(ID)OR Exist(...)?
Postgres: Find position of a specific row within a resultset?
Convert getdate() to EST
Recursive select in SQL
Fastest Way merge two SQLITE Databases
SQL Pivot with String
Getting Grand Totals using Group By
In PostgreSQL how do you insert into a table with only one identity column?
Using value of a column as index in results using PDO
Using column name when using SqlDataReader.IsDBNull
How to make a SUM without group by
How to extract table definitions using SQL or Toad
Insert into table from temporary table
String split column and join to another table
What is the difference between NUMERIC and FLOAT in BigQuery?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!