Temporary tables are used to allow short term use of data in SQL Server. They are of 2 types:

Local

Only available to the current Db connection for current user and are cleared when connection is closed.

Multiple users can’t share a local temporary table.

Global

Available to any connection once created. They are cleared when the last connection is closed.

Can be shared by multiple user sessions.