Chapter III.8. Taking Advantage of Views

Views are powerful objects in SQL Server that allow you to focus on exactly what you want to see within a database. They can be used to show just a few specific columns from a table, or multiple columns from two or more tables.

While views sound a little magical at first, they're really quite simple. If you can create a query, you can create a view.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.