Multidatabase transactions and database types

A database’s durability affects transactions that span multiple databases.

Low-durability databases—user-created temporary databases, in-memory databases, or disk-resident relaxed-durability databases—can participate in a multi-database transaction, even if the coordinating database uses full durability. However, if the coordinating database uses low durability, transactions that span other full-durability databases are not allowed.

**Table 1-2: Database participants in a multidatabase transaction**
Coordinating database	Participant database	Multidatabase transaction
Full durability database	Temporary, in-memory, relaxed-durability, or temporary in-memory database	Allowed
Temporary, in-memory, relaxed-durability, or temporary in-memory database	Temporary, in-memory, relaxed-durability, or temporary in-memory database	Allowed
Temporary, in-memory, relaxed-durability, or temporary in-memory database	Full-durability database	Not allowed