Database Management Systems (2130703)

View

• A View is a virtual table based on the result-set of an SQL statement.

Syntax of view is

 CREATE VIEW view_name AS
 SELECT column1, column2, ...
 FROM table_name
 WHERE condition;

Example of view is

• The view "Current Product List" lists all active products (products that are not discontinued) from the "Products" table. The view is created with the following SQL:

 CREATE VIEW [Current Product List] AS
 SELECT ProductID, ProductName
 FROM Products
 WHERE Discontinued = No