What Is The Difference Between A Local And A Global Temporary Table?

1.	What Is The Difference Between A Local And A Global Temporary Table?
Answer» 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. 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. 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. 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.

Answer»

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.
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.

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.
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.

What Is The Difference Between A Local And A Global Temporary Table?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment