SQL - Temporary Tables

Overview

Temporary tables persist only for the session/connection. Names and lifetime vary by engine.

CREATE TEMPORARY TABLE tmp (id INT, v VARCHAR(20));
INSERT INTO tmp VALUES (1,'a'),(2,'b');
SELECT * FROM tmp;

CREATE TABLE #tmp (id INT, v NVARCHAR(20));
INSERT INTO #tmp VALUES (1,N'a'),(2,N'b');
SELECT * FROM #tmp;

CREATE TEMP TABLE tmp (id INT, v TEXT);
INSERT INTO tmp VALUES (1,'a'),(2,'b');
SELECT * FROM tmp;

id	v
1	a
2	b