0
How Global temporary tables are represented and its scope?

Open 1 Answers 25 Views Technology
How Global temporary tables are represented and its scope?

1 Answer

0

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.

by (53.7k points)
...