Developers often create temporary tables to serve a specific purpose in their data loads.
Languages such as Oracle PL/SQL support the creation of temporary tables, so how about extending the scripting language to allow a construct like
Table A :TEMP //or some equivalent syntax structure
The table would be automatically dropped at the end of script execution in the same way mapping tables are. This would remove the need for people to remember to do manual cleanup.
Or
Table A:AUTODROP
which would automatically drop the (temp) table after its first and next usage. Clean and efficient ?
Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.
