Chapter 12. Views


         There is no object on earth which             cannot be looked at from a               cosmic point of view.

 --Fyodor Mikhaylovich Dostoyevsky

Topics Covered in This Chapter

  • What Are Views?

  • Anatomy of a View

  • Determining and Establishing Views


  • Summary

What Are Views?

As you learned in Chapter 3, a View is a virtual table that comprises the fields of one or more tables in the database; it can also include fields from other views. The reason a View is called a virtual table is because it does not store or contain data—it draws its data from the tables or Views upon which it is based. Because a View does not store data, only its structure is saved in the database, and it is re-created each time it is accessed.


Get Database Design for Mere Mortals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.