Local vs Global Temporary Views

Local vs Global Temporary Views is a SQL statement in the Views category. Temporary views exist only for the duration of a session and are automatically dropped on disconnect. The syntax is -- PostgreSQL: TEMP views are session-scoped. SQL Server: #local vs ##global temp views.. It returns temporary view. A typical example: -- PostgreSQL: CREATE TEMP VIEW high_earners AS SELECT * FROM employees WHERE salary > 100000; -- Only visible to this session -- Automatically dropped when session ends -- SQL Server: CREATE VIEW #local_temp AS SELECT * FROM employees; -- Local temp CREATE VIEW ##global_temp AS SELECT * FROM employees; -- Global temp (all sessions) -- Use cases: -- - Complex queries split into steps -- - Session-specific data transformations --… A close relative is CREATE VIEW, which creates a virtual table based on a SELECT query. Think of it as a saved query that acts like a table.