Suggest an Idea

[AndrewMcIlwrick]

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 ?

[Patric_Nordstrom]

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.

Thanks,

Patric