0
What are the differences between local and global temporary tables?

Open 1 Answers 23 Views Technology
What are the differences between local and global temporary tables?

1 Answer

0

What are the differences between local and global temporary tables?

Local temporary tables are visible when there is a connection, and are deleted when the connection is closed.

CREATE TABLE #<tablename>

Global temporary tables are visible to all users, and are deleted when the connection that created it is closed.

CREATE TABLE ##<tablename>

by (53.7k points)
...