Summary - VIEW

Store a complex query as a view and reuse it.

A VIEW is a virtual table. Created with CREATE VIEW, queried with SELECT, removed with DROP VIEW.

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

Summary VIEW query.

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

Exercise Summary - VIEW

Summary: create the active_customers VIEW.

Show example solution

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