Create a Temporary or In-Memory Table

Create a Temporary or In-Memory Table 
For using PostgreSQL or SQLite 
For a temporary table that is local to the session: 
CREATE TEMP TABLE MyTable(...); 
SQL Server
For a temporary table that is local to the session: 
CREATE TABLE #TempPhysical(...); 
For a temporary table that is visible to everyone: 
CREATE TABLE ##TempPhysicalVisibleToEveryone(...); 
To generate an in-memory table: 
DECLARE @TempMemory TABLE(...);

Create Table

Datasources View Mode

Last modified 1d ago