Modifying Indexed Views

There are two ways you modify an indexed view.  You can modify the view, or you can modify the indexes on the view.

To modify an indexed view

1. In the SQL Server Enterprise Manager, make sure the Databases node is expanded, and that the node for the target database is expanded, too.
   
   
2. Click the Views node, right-click the target view, then choose Design View from the shortcut menu.
   
   
3. Proceed to modify the view by manipulating its definition on the Diagram pane, Grid pane, and SQL pane.

Note   When you save the modified view, its indexes will be deleted and recreated.

To modify the index of an indexed view

1. In the SQL Server Enterprise Manager, make sure the Databases node is expanded, and that the node for the target database is expanded, too.
   
   
2. Click the Views node, right-click the target view, then choose Design View from the shortcut menu.
   
   
3. Right-click the background of the Diagram pane and choose Manage Indexes from the shortcut menu.
   
   
4. Revise the information for the index definition — index name, index columns and their order, index file group, and the other index settings.  For a complete description of these settings, see Indexes Dialog Box.
   
   
5. Click OK.

See Also

Indexed Views | Creating Indexed Views