CREATE VIEW

A statement that defines a view from a query.

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';

Level: Apprentice · More Database terms at this level

Updated