Creating a Global Temporary Table
6>
7> CREATE TABLE ##CustomerSales
8> (
9> ID char (6) NOT NULL,
10> Year smallint NOT NULL,
11> Sales money NOT NULL
12> )
13> GO
1>
The global temporary table will be dropped when the session that created it ends and
when all other processes that reference it have stopped referencing it.
3>
4> drop table ##CustomerSales
5> GO