Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL CREATE OR REPLACE VIEW Keyword

Concept visual

SQL CREATE OR REPLACE VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CREATE OR REPLACE VIEW Keyword

Create Or Replace View

In MySQL and Oracle, a view can be updated with the

Create Or Replace View

command. The following SQL adds the "City" column to the "Brazil Customers" view:

Example

CREATE OR REPLACE 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];

SQL CREATE OR REPLACE VIEW Keyword

Concept visual

SQL CREATE OR REPLACE VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CREATE OR REPLACE VIEW Keyword

Create Or Replace View

In MySQL and Oracle, a view can be updated with the

Create Or Replace View

command. The following SQL adds the "City" column to the "Brazil Customers" view:

Example

CREATE OR REPLACE 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];

SQL CREATE OR REPLACE VIEW Keyword

SQL CREATE OR REPLACE VIEW Keyword

CREATE OR REPLACE VIEW Keyword

Previous

Next

Create Or Replace View

Create Or Replace View

Example

FROM Customers

Query The View

Example

Previous

Next

SQL CREATE OR REPLACE VIEW Keyword

SQL CREATE OR REPLACE VIEW Keyword

CREATE OR REPLACE VIEW Keyword

Previous

Next

Create Or Replace View

Create Or Replace View

Example

FROM Customers

Query The View

Example

Previous

Next