What is the difference between a “Local Temporary Table” and “Global Temporary Table”?

Posted by

To view Verified answers click on the button below.

1. A Local Temporary Table is created by giving it a prefix of # whereas a Global
Temporary Table is created by giving it a prefix of ##.
2. A Local Temporary Table cannot be shared among multiple users whereas a Global
Temporary Table can be shared among multiple users.
3. A Local Temporary Table is only available to the current DB connection for the
current user and are cleared when the connection is closed whereas a Global
Temporary Table is available to any connection once created. They are cleared when
the last connection is closed.