Update Views


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 column1column2, ...
                  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';

Talk to us?

Post your blog