• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 7. Views

A view defines a certain perspective for viewing data. A view’s results are displayed in the form of a virtual table that you can use like a regular table. A view is based on a SQL SELECT command that collects data. You can also use JOIN to compile data from different tables.

You can use views to create simple representations of complex table structures by instructing the system to display only those columns you actually need or to transmit only those rows you actually need when you are dealing with large tables. You can also assign access permissions for views, so that, for example, users can access table-based data only by using views. Thus, for large Microsoft SQL Server installations in particular, users can always only access those columns they are directly authorized to use. All other columns that, for example, might contain additional information for certain programs are hidden from the users and programmers.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint