View
noun
say it: “VYOO” /vjuː/
A saved query with a name that you can select from as if it were 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';
In a sentence
- “The ProductsInStock view saves us rewriting the same query.”
Level: Apprentice · More Database terms at this level
Updated