Was this helpful?
Restrictions
Temporary tables may be subject to the following restrictions:
Temporary tables cannot be used within database procedures.
Temporary tables cannot be used in view definitions.
The following SQL statements cannot be used with temporary tables:
CREATE INDEX
CREATE VIEW
GRANT
HELP
REVOKE
SET LOCKMODE
Repeat queries referencing temporary tables cannot be shared between sessions.
The following commands cannot be issued with a temporary table name:
auditdb
copydb
optimizedb
statdump
verifydb
Last modified date: 01/30/2023