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