Altering identity column

To alter identity column:

Procedure

  1. Log on to the MXDM.
  2. In the Navigation tree pane, click Database.

    MXDM displays a list of available systems in My Systems.

  3. Expand a selected system in the navigation tree.

    List of catalogs for the selected system appears.

  4. Click and expand the contents of a Catalog.

    The list of schemas appears.

  5. Expand a schema in the left pane.

    The Tables folder appears.

  6. Expand the Tables folder and select a table in the left pane.
  7. Right-click the table and select Alter Table from the context menu.
    NOTE:

    Alter Identity Column menu is enabled only if the table contains an Identity Column.

  8. Select Alter Identity Column.

    Alter Identity Column dialog appears.

  9. Select either of the following:
    • Max Value
    • Increment By
    • Recalibrate
    • Recalibrate To
  10. Enter an appropriate value in the Value text box except for Recalibrate option.
  11. Click OK to alter the identity column, else click Cancel to discard the changes.