View

A named query whose result can be used much like a table.

What is View in a relational database?

View — A named query whose result can be used much like a table.

CREATE VIEW active_customer AS
SELECT customer_id, email
FROM customer
WHERE status = 'active';

Level: Apprentice · More Database terms at this level

Updated