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