Views

Overview

• Can act upon a subset of the data in a table as if that subset were the entirety of the table (single-table views)
• Can act upon related data in a set of tables as if the data were all in a single table (multi-table views)

• Views are virtual tables with a different structure than the actual tables
• The tables that are the used in a view are called "base tables"
• A view can use other views, as well as tables