Local and global temporary table in sqlserver


Normal tables are exactly that, physical tables defined in our database.
Local temporary tables are temporary tables that are available only to the session that created them.
These tables are automatically destroyed at the termination of the procedure or session that created them.
Global temporary tables are temporary tables that are available to all sessions and all users. They are dropped automatically when the last session using the temporary table has completed. Both local temporary tables and global temporary tables are physical