Dropping an index

To drop an index:

Procedure

  1. In the navigation tree pane, select a catalog and then expand Schemas folder within it.

    List of schemas appears.

  2. Expand a selected schema and select Tables folder.
  3. Expand the Tables folder.

    List of tables appears.

  4. Select and expand a table within it.

    Indexes and Triggers folders appear.

  5. Expand the Indexes folder.

    List of indexes appears.

  6. Select an index name and then right-click and select Drop Index.

    Confirm Drop Index dialog with Cascade and Restrict options appears.

  7. Select either of the following options:

    • Restrict— If the index is being used to validate a constraint, then the index is not dropped.

    • Cascade — If the index is being used to validate a constraint, both the constraint and index are dropped.

  8. Click Yes to drop the selected index.