Differences between temporary and permanent tables

Compared to permanent tables, temporary tables differ in these ways:
  • They have fewer types of constraints available.
  • They have fewer options that you can specify.
  • They are not visible to other users or sessions.
  • They do not appear in the system catalog tables.
  • They are not preserved, as described in the section Duration of temporary tables.

The INFO statement and the Info Menu option of DB-Access cannot reference temporary tables.