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
hope this will help you