Temp tables are constructs which
exist for a limited time in SQL Server, usually the lifetime of a connection.
There are a few restrictions for temp tables, like they cannot be partitioned
and cannot have FKs. They can have indexes and constraints.
Temporary tables cannot be partitioned
Temporary tables cannot reference or be referenced by FOREIGN KEY constraints
When a session creates temporary table that contains a named
constraint inside a transaction, another sessions cannot create a
temporary table of the same name until the first session commits the