Collection Contents Index Validity checking Defining a view pdf/chap16.pdf

First Guide to SQL Anywhere Studio
   PART 3. Basic SQL     

CHAPTER 16. Introduction to Views


About this chapter 

It is often impractical to repeatedly type complicated queries. SQL provides views, that allow you to give names to frequently executed SELECT commands. A view is a computed table which is useful for security purposes, and for tailoring the appearance of database information to make data access straightforward.

This chapter introduces you to views.


  Defining a view
  Using views for security

Collection Contents Index Validity checking Defining a view pdf/chap16.pdf