Building a View

  • Robin Dewson
Chapter

Abstract

A view is a virtual table that, in itself, doesn’t contain any data or information. All it contains is the query that the user defines when creating the view. A view is a named query that can be used against one or more tables. Views are used as a security measure by restricting users to accessing only certain columns or rows from an underlying table, as a method of joining data from multiple tables and presenting it as if that data resided in one table, and as a method of returning summary data instead of detailed data.

Keywords

Share Price Select Statement Base Table Multiple Table View Definition 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Robin Dewson 2015

Authors and Affiliations

  • Robin Dewson
    • 1
  1. 1.BROMHAMUK

Personalised recommendations