Selecting an index to support ROWID

To select an index to support the ROWID function, use the following procedure in the Data Dictionary with the schema holder connected (you do not have to connect to the MS SQL Server database).

  1. Choose Tables mode.
  2. Select the table whose ROWID you want to modify.
  3. Choose Table Properties.
  4. Choose DataServer.

    The following dialog box appears:



  5. Double-click an index name listed in the Name field to display detailed information about its attributes.

    The following dialog box appears:



  6. Choose OK to return to the ROWID Choices dialog box.
  7. Select the index you want to use to support ROWID.
  8. Choose OK to return to the Table Properties dialog box.