This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.