Can i ask what syntax is required to create and drop temporary tables in DbVis. I am used to the SQL server syntax below. This throws an error message for me. I am currently running DbVisualizer Pro 10.0.27
This should work with the syntax you use.
Make sure to use the correct database and schema for the source table.
Below example is from DbVisualizer and SQL Server.