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 and select Add New View. From there, you build the select statement just as you would for any other SQL statement.

Clicking the Update button creates (or updates) the view in the database.