sa_reset_identity( 
tbl_name, 
owner_name, 
new_identity 
)

The next identity value generated for a row inserted into the table is new_identity + 1.

No checking occurs to see whether new_identity + 1 conflicts with existing rows in the table. For example, if you specify new_identity as 100, the next row inserted gets an identity value of 101. However, if 101 already exists in the table, the row insertion fails.

If owner_name is not specified or is NULL, tbl_name must uniquely identify a table in the database.

The sa_reset_identity system procedure cannot be used on a table having no columns with a default of either AUTOINCREMENT or GLOBAL AUTOINCREMENT.

DBA authority

Causes a checkpoint to occur after the value has been updated

• The AUTOINCREMENT default
• The GLOBAL AUTOINCREMENT default

The following statement resets the next identity value to 101:

CALL sa_reset_identity( 'Employees', 'DBA', 100 );