This documentation is archived and is not being maintained.

How to: Create Views (Visual Database Tools)

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.

  1. In Object Explorer, right-click the Views node, then choose Add New View from the shortcut menu.

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

    ms175503.note(en-US,SQL.90).gifNote:
    Although you can design the view as you would design a SELECT query, there are some restrictions. For more information, see Views (Database Engine).

Show: