Database updating view
The following Transact-SQL statement selects all the data for the view shown in Listing 9.1, sorting the result set on the Company Name column: statement wouldn't have to change. Company Name Views are created inside individual databases, however, views can reference tables and views in other databases or even on other servers (if the view is defined using distributed queries).
The information about where the data in a view comes from and how it is pulled together from various tables is all encapsulated inside the view. Here are some general guidelines for creating views: Views are frequently used as security mechanisms to prevent users from having direct access to tables while still allowing them to work with data.
Views, which are a type of virtual tables allow users to do the following − Database views are created using the CREATE VIEW statement.
The same rules that apply to the UPDATE command also apply to the INSERT command.
The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
A user can query a single view instead of having to learn complex join syntax and understand the structure of your database.
As far as the user is concerned, the view looks just like a table.