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