SQL Updating a View:-
A view can be updated with the CREATE OR REPLACE VIEW
statement.
SQL CREATE OR REPLACE VIEW Syntax.
Example:- CREATE OR REPLACE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
SELECT column1, column2, ...
FROM table_name
WHERE condition;
The following SQL adds the "City" column to the "India Customers" view:
Example:- CREATE OR REPLACE VIEW [India Customers] AS
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = 'India';
SELECT CustomerName, ContactName, City
FROM Customers
WHERE Country = 'India';