What is View?

A simple view can be thought of as a subset of a table. It can be used for retrieving data, as
well  as  updating  or  deleting  rows.  Rows  updated  or  deleted  in  the  view  are  updated  or
deleted  in the table the view was created with.  It should also be noted that as data  in the
original table changes, so does data in the view, as views are the way to look at part of the
original table. The results of using a view are not permanently stored  in the database. The
data accessed through a view is actually constructed using standard T‐SQL select command
and can come from one to many different base tables or even other views.