Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL CREATE VIEW Keyword

Concept visual

SQL CREATE VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CREATE VIEW Keyword

Create View

The CREATE VIEW

command creates a view. A view is a virtual table based on the result set of an SQL statement. The following SQL creates a view that selects all customers from Brazil:

Example

CREATE VIEW [Brazil Customers] AS

Select

CustomerName, ContactName

FROM Customers

Where

Country = "Brazil";

Query The View

We can query the view above as follows:

Example

SELECT * FROM [Brazil Customers];

SQL CREATE VIEW Keyword

Concept visual

SQL CREATE VIEW Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CREATE VIEW Keyword

Create View

The CREATE VIEW

command creates a view. A view is a virtual table based on the result set of an SQL statement. The following SQL creates a view that selects all customers from Brazil:

Example

CREATE VIEW [Brazil Customers] AS

Select

CustomerName, ContactName

FROM Customers

Where

Country = "Brazil";

Query The View

We can query the view above as follows:

Example

SELECT * FROM [Brazil Customers];

SQL CREATE VIEW Keyword

SQL CREATE VIEW Keyword

CREATE VIEW Keyword

Previous

Next

Create View

The CREATE VIEW

Example

Select

FROM Customers

Where

Query The View

Example

Previous

Next

SQL CREATE VIEW Keyword

SQL CREATE VIEW Keyword

CREATE VIEW Keyword

Previous

Next

Create View

The CREATE VIEW

Example

Select

FROM Customers

Where

Query The View

Example

Previous

Next