Ans :

A local temporary table is created using CREATE TABLE statement with the table name prefixed with single hash sign (#table_name). Local temp tables are only available to the SQL Server session or connection (means single user) that created the tables. These are automatically deleted when the session that created the tables has been closed.

You may also like