Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL ALTER VIEW Keyword

Concept visual

SQL ALTER VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALTER VIEW Keyword

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];

SQL ALTER VIEW Keyword

Concept visual

SQL ALTER VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALTER VIEW Keyword

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];

SQL ALTER VIEW Keyword

SQL ALTER VIEW Keyword

ALTER VIEW Keyword

Previous

Next

Alter View

Example

FROM Customers

Query The View

Example

Previous

Next

SQL ALTER VIEW Keyword

SQL ALTER VIEW Keyword

ALTER VIEW Keyword

Previous

Next

Alter View

Example

FROM Customers

Query The View

Example

Previous

Next