Views

A view is a virtual table based on a specified SELECT statement. A view is a dynamically controlled picture of the contents in a database and allows a programmer to determine what information the user sees and manipulates. Different users can be given different views of the contents of a database, and their access to those contents can be restricted in several ways.