Creating SQL Views

  1. From the tree view, expand the server containing the database you want to modify.

  2. Expand the database for which you want to create the view.

  3. Click the Views node.

    An input form appears in the properties view.

  4. Type a name for the view in the View Name box.

  5. Type the columns names (separated by commas) of a selected table in the Enter Column Names box.

  6. Type a query statement in the SQL View Query box.

  7. Click Store.

Prev  Up  Next
Modifying Integrity Constraints  Home  Modifying SQL Views