What is the difference between a Local and a Global temporary table?

Posted by

To view Verified answers click on the button below.

1. A local temporary table exists only for the duration of a connection or, if defined
inside a compound statement, for the duration of the compound statement.

2. A global temporary table remains in the database permanently, but the rows exist
only within a given connection. When connection is closed, the data in the global
temporary table disappears. However, the table definition remains with the
database for access when database is opened next time.