Start a new topic

Temporary Tables

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

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;

Login or Signup to post a comment