How can we help you today?
Temporary Tables
1 Comment
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