What is view? Meaning and example

What is view?

View: A stored query that behaves like a virtual table. It holds no data of its own; each use runs the underlying query. Views simplify complex joins, hide sensitive columns and give stable interfaces.

Level: intermediateTopic: SQL databases

View: an example

CREATE VIEW active_customers AS SELECT * FROM customers WHERE status = 'active'; lets analysts query it like a table.

Related terms

Materialized view
SELECT
Common table expression

More SQL databases terms

WHERE
Window frame
Window function
Write-ahead log
ACID
Aggregate function
ALTER TABLE
Atomicity

Where you learn it

View is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.