0 votes
in Technology by (54.6k points)
What are the differences between local and global temporary tables?

1 Answer

0 votes
by (54.6k points)

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>

...