How to view the indexes on a table (Enterprise Manager)

To view the indexes on a table

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, point to All Tasks, and then click Manage Indexes....
4. In Existing indexes, click the name of the index to modify, and then click Edit....

See Also