Hi,
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.
SELECT *
INTO #tempTable1
FROM master.guest.newtable;
select*from #tempTable1;
DROPTABLE #tempTable1;
Steven Lewis
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
SELECT *
INTO #tempTable1
FROM Table