RSS‎ > ‎

SQL :: What is the difference between a local and a global table?

posted Aug 29, 2012, 3:08 AM by Ashish Jain
local temporary table exists only for the duration of a connection or, if defined inside a compoundstatement, for the duration of the compound statement.
global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection are 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.