Altering identity column
To alter identity column:
Procedure
- Log on to the MXDM.
-
In the Navigation tree pane, click
Database.
MXDM displays a list of available systems in My Systems.
-
Expand a selected system in the navigation tree.
List of catalogs for the selected system appears.
-
Click and expand the contents of a Catalog.
The list of schemas appears.
-
Expand a schema in the left pane.
The Tables folder appears.
- Expand the Tables folder and select a table in the left pane.
-
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.
-
Select
Alter Identity Column.
Alter Identity Column dialog appears.
-
Select either of the following:
- Max Value
- Increment By
- Recalibrate
- Recalibrate To
- Enter an appropriate value in the Value text box except for Recalibrate option.
- Click OK to alter the identity column, else click Cancel to discard the changes.