MS SQL Basics Tutorial: Viewing and modifying indexes

8.3.1 View and modify indexes with Enterprise Manager

Selecting the database to view in Enterprise Manager, and then selecting the Tables & Indexes page box in the taskpad, displays the index information for all the user tables for this database in the taskpad, as shown in Figure 8-11.

To view and modify the details of the index, right-click on the table you want to view, select the Manage Indexes option from the All Tasks submenu from the shortcut menu, and the Index Management dialog box appears as shown in Figure 8-9. Select the index you want to view or modify, click the Edit button, and the Modify Index dialog box appears as shown in Figure 8-12.

In the Modify Index dialog box shown in Figure 8-12, you can modify most of the index's settings and directly modify its SQL script simply by pressing "Edit SQL ..." button to display the SQL Script edit box as shown in Figure 8-13. The SQL script in which the index can be edited, tested, and run.