Regular user tables

You can create regular user tables in tempdb by specifying the database name in the command that creates the table:

create table tempdb..temptable (...)


select select_list
    into tempdb..temptable

Regular user tables in tempdb:

You can create indexes in tempdb on permanent temporary tables:

create index tempix on tempdb..temptable(col1)