A View is a collection of one or more tables. A View can have whole table data or selected rows depends on conditions applied. A View is similar to a table but provide more functionality as compared to tables.
A View provide the following features:

• Select, Insert, Update, delete can be applied on View.
• Any changes to view will be updated in the corresponding tables.
• A View can be drop with the Drop Command.
• Indexing can be applied on View.

Syntax:

Create View [Schema_Name].[View_Name]
AS
SELECT column_name(s)
FROM table_name
WHERE condition