SQL CREATE VIEW Keyword
CREATE VIEW command creates a view.
A view is a virtual table based on the result set of an SQL statement.
The following SQL creates a view that selects all customers from Brazil:
SELECT CustomerName, ContactName
WHERE Country = "Brazil";
Query The View
We can query the view above as follows: