Views in SQL
From the SQL cheat sheet · Views & Stored Procedures · verified Jul 2026
Views
Save queries as reusable virtual tables.
sql
-- Create view
CREATE VIEW active_users AS
SELECT id, name, email
FROM users WHERE status = 'active';
-- Use it like a table
SELECT * FROM active_users WHERE age > 25;
-- Replace existing view
CREATE OR REPLACE VIEW user_summary AS
SELECT u.name, COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
GROUP BY u.id, u.name;
-- Drop view
DROP VIEW IF EXISTS active_users;💡 Views simplify complex queries — define once, use everywhere like a table
⚡ Materialized views (PostgreSQL) cache results for faster reads — great for dashboards
📌 Regular views re-run the query each time; materialized views store the result
🟢 Views are great for access control — expose only certain columns to certain users
viewsmaterialized-views