A view is a saved
SELECT statement. A view can retrieve data from one or more tables. After you create a view, you can select data from it just as you can select it from a table. In this lesson, you learn:
What views are and why you would want to use them
How to use the SQL Server Management Studio Query Builder to create a view
How to use T-SQL to create or modify a view
Views can ...