VietMX's Blog

What’s the difference between a local temp table and a global temp table?

Technology Community › Category: SQL › What’s the difference between a local temp table and a global temp table?
0 Vote Up Vote Down
VietMX Staff asked 3 years ago
  • Local tables are accessible to a current user connected to the server. These tables disappear once the user has disconnected from the server.
  • Global temp tables, on the other hand, are available to all users regardless of the connection. These tables stay active until all the global connections are closed.
Question Tags: ,

DMCA.com Protection Status