I want to avoid to remove any real table on resource closing (= dropping of temporary table).How to I force "drop only temporary"? Prefix, option, etc.
If you have to explicitly drop a temporary table you are likely doing something wrong. When you create the table you tell it when to go away and at that time it will - no need for a drop statement.
David J.
