What is a VIEW?

Create a virtual table.

A VIEW is a virtual table. It stores a named query and can be queried like a table.

CREATE VIEW active_customers AS
SELECT * FROM customers WHERE status = 'active';

Virtual table for active customers.

The view active_customers is created. All columns are selected from customers. WHERE keeps only the rows where status = 'active' holds.

What is a VIEW? — details

A VIEW stores no data; it stores the query. When queried, the underlying query runs.

For example, if you save a frequently used JOIN as a view named active_customers, everyone can reach the same data without knowing the complex query.

Create a VIEW named active_customers.

Show example solution

CREATE VIEW active_customers AS
SELECT * FROM customers WHERE status = 'active';

Add CREATE VIEW

CREATE ____ active_customers AS
SELECT * FROM customers WHERE status = 'active';

Show answer

CREATE VIEW active_customers AS
SELECT * FROM customers WHERE status = 'active';

Next lesson: CREATE VIEW