Previous Topic Next topic Print topic


To create a new index or key

To create an index or key on a table in the current location:

  1. Click SQL for DB2 on the Tools menu; then click SQL Wizard.
  2. If the Catalog Browser window is not open, click
    *
    to open it.
  3. On the Catalog Browser window, ensure the Table tab is selected.
  4. Click the table you want.
  5. Click Alter.
  6. Click Create in the Indexes and Keys group.
  7. Type a name for your index or key.
  8. Select the type of index or key you want to create.
  9. Use the arrow pushbuttons to create a list of columns that define the index or key.
  10. When you have finished, click OK to close the Create Index dialog box.

    You can look at the SQL statements that will be used to make your changes by clicking SQL.

  11. Click OK to close the Alter Table window.
Previous Topic Next topic Print topic