view (object)

A virtual table generated by a query whose definition is stored in the database. For example, a view might be defined as containing three out of five available columns in a table, in order to limit access to certain information. Views can be treated as tables for most database operations, including select queries. Any operations performed on views affect the data in the table or tables on which the view is based.