Creating Views

Because a view is saved in the database and a query is not, the process of creating a new view is different from the process of creating a query.

To create a view

  1. In the SQL Server Enterprise Manager, right-click the Views node, then choose New View from the shortcut menu.

  2. Proceed to design the view as you would design a SELECT query.

    Note   Although you design the view as you would design a SELECT query, there are some restrictions.  For more information, see Comparison of Queries and Views.

See Also

Creating Indexed Views

Show: