Was this helpful?
Temporary Table Restrictions
Temporary tables are subject to the following restrictions:
A temporary table cannot be used within a database procedure. It can, however, be used as an input parameter to a database procedure if it is the only parameter and the procedure is not row producing.
A temporary table cannot be used in a view definition.
Integrities, constraints, or user-defined defaults cannot be created for temporary tables. (The with|not null and with|not default can be specified.)
A temporary table cannot be modified to use a different page size.
Repeat queries referencing temporary tables cannot be shared between sessions.
A temporary table cannot be partitioned.
All SQL statements can be used with temporary tables except the following:
ALTER TABLE
COMMENT ON
CREATE INTEGRITY
CREATE PERMIT
CREATE RULE
CREATE SECURITY_ALARM
CREATE SYNONYM
CREATE VIEW
GRANT
HELP
REVOKE
SAVE
SET JOURNALING
SET LOCKMODE
The following commands cannot be issued with a temporary table name:
auditdb
copydb
optimizedb
statdump
verifydb
usermod
genxml
xmlimport
Last modified date: 08/29/2024