You cannot include a referential integrity constraint that references a column on a local temporary database unless it is from a table on the same local temporary database. create table fails if it attempts to create a reference to a column on a local temporary database from a table in another database.
You cannot encrypt a column with an encryption key stored in a local temporary database unless the column’s table is on the same local temporary database. create table fails when it attempts to encrypt with an encryption key located on the local temporary database and the table is on another database.