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 ...
Get Sams Teach Yourself SQL 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.