CREATE VIEW
noun
say it: “kree-AYT VYOO” /kriˈeɪt vjuː/
The SQL statement that saves a query as a view with a name.
What is CREATE VIEW in a relational database?
CREATE VIEW — A statement that defines a view from a query.
CREATE VIEW active_customer AS
SELECT customer_id, email
FROM customer
WHERE status = 'active';
In a sentence
- “I used CREATE VIEW to save the order totals query.”
Level: Apprentice · More SQL terms at this level
Updated