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)