Views
A view appears like a table to an application program. However, a view contains no data and only logically represents one or more tables over which it is created.
A view can contain all the columns and rows of the given tables or a subset of them. The columns can be arranged differently in a view than they are in the tables from which they are taken. A view in SQL is a special form of a nonkeyed logical file.
Parent topic:
SQL objects
Related reference
Views