O'Reilly logo

Sams Teach Yourself SQL by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 20. Creating and Using Views and Synonyms

During this hour, you learn about performance, as well as how to create and drop views, how to use views for security, and how to provide simplicity in data retrieval for end users and reports. You also will read a discussion on synonyms.

The highlights of this hour include:

  • What views are

  • How views are used

  • Views and security

  • Storage of views

  • Creating views

  • Joining views

  • Data manipulation in a view

  • What synonyms are

  • Managing synonyms

  • Creation of synonyms

  • Dropping synonyms

What Is a View?

A view is a virtual table. That is, a view looks like a table and acts like a table as far as a user is concerned, but it doesn’t require physical storage. A view is actually a composition of a table in the form of a predefined ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required