Altering an Index

When you alter an index, the index is actually dropped and recreated using your new specifications.

Additional options are provided for those requiring compatibility with mainframe DB2 or other XDB Server-supported databases.

To alter an existing index:

  1. Click the Alter command from the Table menu.

    SQLWizard displays the Open Table dialog box.

  2. Choose the desired table and click OK. If you need to change column specifications for an existing table, make these entries before proceeding.
    Note:


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

  3. Choose an index from the Indexes And Keys list on the Alter Table dialog box either by double clicking on an index name or by highlighting a name and clicking the Alter button.
  4. Modify the column selection using the arrow buttons.
  5. Change any DB2-related index items by clicking on the Options button. These include the equivalents of Using Blocks, Free Blocks, Clusters, Buffer Pools and other options.
  6. Click OK to accept the changes.

    SQLWizard returns you to the Alter Table dialog box. An asterisk (*) precedes the index entry in the Indexes And Keys list to show that the index definition has been changed.

  7. Click OK to exit the Alter Table dialog box.
  8. Click OK to confirm altering the table.

    SQLWizard modifies the index specifications on the selected table.