Microsoft® Visual Studio® 2010 Unleashed

Creating Views

Views are virtual tables. They look and act just like tables in the database but are, in reality, select statements that are stored in the database. When you look at the content of a view, you are actually looking at the resultset for a select statement.

Because views are implemented as select statements, you create them using the Query/View Designer tool. In Server Explorer, right-click the Views folder under the database where you want to create the view. From there, you build the select statement just as you would for any other SQL statement.

Saving the view refreshes the database’s copy of the view’s select statement.