Creating local and global user temporary databases

You can create local and global user temporary databases at any time.

You must create a local user temporary database from the owning instance. For example, to create the local temporary database local_temp1 on ase1, enter:

create temporary database local_temp1 
	for instance ase1 on default = 50

You can create a global user temporary database from any instance in the cluster. For example, to create the global temporary database global_tempdb1 on ase1, log in to ase1 and enter:

create global temporary database global_tempdb1
	on default = 50

NoteThe create database phrase for instance instance_name is optional. If you do not include this phrase, Adaptive Server creates the temporary database for the current instance. See the Reference Manual: Commands for a description of its complete syntax.