Summary
Views and synonyms, two important features in SQL, were discussed this hour. In many cases, these things are not used when they could aid in the overall functionality of relational database users. Views were defined as virtual tables—objects that look and act like tables, but do not take physical space like tables. Views are actually defined by queries against tables and possible other views in the database. Views are typically used to restrict data that a user sees and to simplify and summarize data. Views can be created from views, but care must be taken not to embed views too deeply, to avoid losing control over their management. There are various options when creating views, some implementation-specific.
Synonyms, objects in the ...
Get Sams Teach Yourself SQL in 24 Hours, Second Edition 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.
