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 live online training, plus books, videos, and digital content from nearly 200 publishers.