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