Advertisement

Building a View

  • Robin Dewson

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. You can think of a view as a stored query. Views are used as a security measure by restricting users to certain columns or rows, as a method of joining data from multiple tables and presenting it as if it resides in one table, and to return summary data instead of detailed data.

Keywords

Error Message Enterprise Manager Select Statement Query Analyzer Building Index 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robin Dewson 2001

Authors and Affiliations

  • Robin Dewson

There are no affiliations available

Personalised recommendations