0 votes
in Technology by (54.6k points)
How Global temporary tables are represented and its scope?

1 Answer

0 votes
by (54.6k points)

How Global temporary tables are represented and its scope?

Global temporary tables are represented with ## before the table name. Scope will be the outside the session whereas local temporary tables are inside the session. Session ID can be found using @@SPID.

...