Dropping a Single Index from a Table

Access the Index Selection Tool form.

The instructions in this section assume that you have already selected a table and a specific data source from which you want to drop the table index.

  1. Expand the data source node to view the indexes for the table.

  2. To flag an index, select an index and then click the Flag/Unflag Index button.

  3. To drop a single index, select a flagged index and then click the Drop Single Index button.

  4. On Drop Single Index, click one of these options and then click OK:

    • Use proxy user and password.

    • Specify user and password.

      This option activates the Owner ID and Password fields, which you must complete before clicking OK.

  5. On the dialog box, click OK to continue.