Regular user tables

To create regular user tables in a temporary table, specify the database name in the create table command:

create table tempdb..temptable (...)

Regular user tables in the temporary database:

• Can persist across sessions

• Can be used by bulk copy (bcp) operations

• Can be shared by granting permissions on them

• Must either be explicitly dropped by the owner or are automatically removed when Adaptive Server is restarted

or:

select select_list
into tempdb..temptable

You can create indexes on regular user tables created in the temporary database:

create index tempix on tempdb..temptable(col1)