Chapter 9. Designing and Creating Views, Inline Functions, and Synonyms
Exam objectives in this chapter:
Create Database Objects
Create and alter views (simple statements).
Design views.
Work with Data
Query data by using SELECT statements.
Microsoft SQL Server provides three different ways to present a logical view of a table to user queries without having to expose the physical base table directly. Views behave just like tables but can hide complex logic; inline functions can be used like views but also take parameters; and synonyms are a simple way to refer to database objects under a different name.
In this chapter, you learn to design, create, and modify objects that present data tables for your T-SQL code in indirect ways.
Lessons in this chapter ...
Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 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.
