What is a View?

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.


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