Alter View
In SQL Server, a view can be updated with the ALTER VIEW command.
The following SQL adds the "City" column to the "Brazil Customers" view:
Example
ALTER VIEW [Brazil Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = "Brazil";Query The View
We can query the view above as follows:
Example
SELECT * FROM [Brazil
Customers];