Global Temporary Table in sql server

Published on by LakshmiSaahul,Dhana Royal

Global Temporary Table:

Global Temporary tables are visible to or available across all sessions. And all users.

Global Temporary tables are created using the same syntax as a CREATE TABLE except the table name starts with "##" (two '#' signs). When the table is only "##", it is defined as a local global temporary table and it's scope is not limited to the session it is created in.

A Global Temporary table is dropped automatically when the last session using the temporary table has completed.

Both the local temporary tables and global temporary tables are physical.

Advertising
To be informed of the latest articles, subscribe:
Comment on this post