VIEW (SQL)

WHAT IS A VIEW

View is a virtual table whose contents are defined by a query.

A view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

It is a virtual table computed or collated dynamically from data in the database when access to that view is requested.Changes applied to the data in a relevant underlying table are reflected in the data shown in subsequent invocations of the view.

CREATE VIEW SYNTAX

CREATE VIEW [ViewName]
AS
SELECT statement

Ex :

CREATE VIEW test
AS
SELECT empid,
              empname,
              empaddress
FROM employee

Get Result from view :

SELECT * FROM test

DROP VIEW

DROP VIEW ViewName

Ex: Drop View test