View

Also known as · Views / Indexes

A stored query that behaves like a virtual table and holds no data of its own.

sql
CREATE VIEW active_customers AS SELECT customer_id, first_name FROM customer

When to use

Use it to save a complicated query under a name, then query it like a table. Covered in the study guide's views section.

See Read 01.

Appears in

No references yet.