Chapter 15. Views
After completing this chapter, you will be able to
Understand views.
Create, alter, and drop views.
Create index views.
Part IV of this book focused on the T-SQL language as a whole and many of the available constructs and keywords. All of the T-SQL code you’ve written so far has been disposed, meaning it is not reusable. In this part of the book, you are going to focus on writing code that creates reusable objects within the database. The discussion will begin with views and move on to other reusable T-SQL objects.
What are views?
A view is a virtual object or table whose result set is derived from a query. It is very similar to a real table because it contains columns and rows of data. The only time a view is materialized, or stored ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
