SQL CREATE OR REPLACE VIEW keyword usage and examples

SQL Keyword Reference

CREATE OR REPLACE VIEW (Create or Replace View)

The CREATE OR REPLACE VIEW command will update the view.

The following SQL adds the "City" column to the "Brazil Customers" view:

CREATE OR REPLACE VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "Brazil";

Query View

We can query the following views:

SELECT　*　FROM [Brazil　
　　Customers];

SQL Keyword Reference