Progress
Basic Database
Tools


Changing the Primary Index for a Table

Follow these steps to change the primary index for a table:

NOTE: A word index cannot be the primary index.

  1. Choose Schema Index Editor. Progress alphabetically lists all the tables defined for your database.
  2. Select a table.
  3. Choose the ChangePrimary option from the menu at the bottom of the window. Progress prompts you to verify that you want to make the selected index the primary index for the table.
  4. Choose Yes to make the selected index the primary index for the table. Progress returns you to the Index Editor.
  5. Choose Exit to apply the change. Progress displays an alert box asking if you want to apply or undo the changes to the database, or if you want to make other changes.
  6. Choose Apply Changes. Progress returns you to the Data Dictionary main window.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095