- In the Database window, click Queries
under Objects, click the indexed view you want to open, and then click Design on the database window toolbar. - Modify the view in the Diagram and Grid panes of the Query Designer.
Note When you save the modified view, its indexes will be deleted and recreated.
Modify the index of an indexed view
- In the Database window, click Queries under Objects, click the indexed view you want to open, and then click Design on the database window toolbar.
- Right-click the background of the Diagram pane and choose Manage Indexes from the shortcut menu.
- Revise the information for the index definition
— index name, index columns and their order, index file group, and the other index settings. For more information about each dialog box option, click Help.