---
title: "What is difference between Local Temp Table vs Global Temp Table?"  
description: "What is difference between Local Temp Table vs Global Temp Table?"  
author: "Anubhav Sharma"  
published: 2026-05-11  
updated: 2026-05-12  
canonical: https://answers.mindstick.com/qa/116585/what-is-difference-between-local-temp-table-vs-global-temp-table  
category: "database"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

# What is difference between Local Temp Table vs Global Temp Table?

What is [difference](https://yourviews.mindstick.com/story/5016/chia-vs-basil-seeds-what-s-the-difference) between [Local](https://yourviews.mindstick.com/view/84877/discovering-the-hidden-gems-of-sikkim-with-a-local-tour-guide-mr-akshey-dasgupta) [Temp Table](https://www.mindstick.com/forum/158046/what-is-the-difference-between-a-temp-table-and-a-variable-table-in-sql-server) vs [Global](https://www.mindstick.com/articles/13127/macro-and-microeconomics-concepts-in-relation-to-global-organization-management) Temp Table?


---

Original Source: https://answers.mindstick.com/qa/116585/what-is-difference-between-local-temp-table-vs-global-temp-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.