What are the temporary tables?

The concept behind the temporary table is very simple and it is also an interview question?

Types of temporary tables?

The temporary tables are two types they are as follows.

• Local temporary tables
• Global temporary tables

Local temporary tables:

• Prefixed with # (single pound)
• Visible to only session of the server
• Dropped automatically if you close the session.

Global temporary tables:

• Prefixed with ## (two pounds)
• Visible to all the sessions of the server
• Dropped automatically if you close the session.

Note: 

We can not create foreign key on temporary tables. Mainly we cannot delete these tables, but sometimes its better drop explicitly if connection pooling is enabled.