By 25/02/2016 1 Comments

How To Update Or REPLACE VIEW In SQL?

  • In SQL an exist VIEW can be updated or replaced by CREATE OR REPLACE statement.

Syntax:

CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Example: Remove column (location) from VIEW (view_country) & select countries which have 1 and 3 (country_id)

CREATE OR REPLACE VIEW view_country AS
SELECT country_id, country_name
FROM country
WHERE country_id IN (1,3);







Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .