Creating a Temporary or In-Memory Table

Learn how to create a Temporary or In-Memory Table in Kuika.

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(...);