Home

Monday, 4 July 2016

Difference between Global and Local Temporary Table

Global Temporary Table-

Global temp table are visible for all users and its is deleted when the created connection is closed.

e.g Create table ##<tab name>;

Local Temporary Table

Local Temp table are visible for only current user and its available when these in connection and they are deleted when connection closed.

e.g Create table #<tab name>;

No comments:

Post a Comment