Firstly, although a view appears to operate in the same manner as a table, it is not always possible to insert data into a view or update information.
This database has been constructed and populated with data throughout the course of the tutorial.
If you do not have a working copy of the database, download the script from the top of this page and execute it to create a database.
A second common use for a view is to hide information from users.
If a table includes a column containing sensitive data, a view of the table can be created that omits the column.
This report may include general customer information from the Accounts table.
For financial data, this may be combined with aged debt information from the Debt table, outstanding orders from the Orders table and other information from the Quotes and Invoices tables.
The security features of SQL Server can then allow access to the view but prevent direct reading of the table according to the user's privileges.
You can also hide information by using a WHERE clause so that only selected rows are accessible.
Views are generally used to simplify access to a complex schema.