CREATE OR REPLACE VIEW

The CREATE OR REPLACE VIEW command alters a view. In the given SQL, it incorporates the “City” column into the “Brazil Customers” view.

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

Query The View

To retrieve data from the aforementioned view, we can execute the following query.

SELECT * FROM [Brazil Customers];