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

1 Answer

0 votes
by (55.8k 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>

...