Dropping an Index

When you drop an index using the Alter Table facility, there is no effect on the table data because the index is a structure independent of the table.

Once index specifications are saved for a table, you can drop them by reopening the Create/Alter/Drop Table dialog box and accessing the Alter Index dialog box. You can also use the Undo button from this dialog box to cancel a drop index specification before resaving the table information from the Create/Alter/Drop Table dialog box. Once completed, SQLWizard drops the old index and creates a new one using the new specifications you provide, if any.

To drop an index:

  1. Click the Drop command from the Table menu.

    SQLWizard displays the Open Table dialog box.

  2. Choose the desired table and click OK.

    SQLWizard displays the Drop Table dialog box.

    Note:


    *
    From the Catalog Browser dialog box, click the Table tab and choose a table; then click the Drop button.

  3. Choose an index from the Indexes And Keys list on the Drop Table dialog box by highlighting a name and clicking the Drop button.

    SQLWizard modifies the index entry by preceding it with a - sign to indicate it will be dropped when exiting the Drop Table dialog box.

    Note:

    If you decide you want to keep an index before exiting the Drop Table dialog box, double click the name of the index to display the Drop Index dialog box. Click the Undo button. The - sign will be removed and the index will remain intact.

  4. Click OK from the Drop Table dialog box to drop all indexes that have the - sign.
  5. Click OK to confirm altering the table.

    SQLWizard drops the selected indexes on the selected table.