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.

  For more information, see Duration of Temporary Tables.

In Extended Parallel Server, you can use the following data definition statements on a temporary table from a secondary coserver: CREATE Temporary TABLE, CREATE INDEX, CREATE SCHEMA, DROP TABLE, and DROP INDEX.

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