Cry How to...
Create a temporary table
Creating a temporary table is virtually the same as creating a normal
table. The main exception is the naming of the table. A hash ('
as the first character in the table name denotes that it is a temporary
There are two types of temporary tables, local and global.
A local temporary table has a single hash ('
#') at the start
of its name. A local temporary table is visible only to the user who created
it and is destroyed automatically when that user disconnects.
A global temporary table is denoted by a name starting with two hashes
##'). A global temporary table is visible to all users
and is deleted automatically when the last user who has referenced the table
An example of creating a local temporary table:
create table #foo
An example of creating a global temporary table:
create table ##baz
These notes have been tested against SQL Server 7 and are believed to be correct for later versions as well.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.