sa_reset_identity system procedure

sa_reset_identity( 
tbl_name 
[, owner_name 
[, new_identity ] ]
)

tbl_name Use this CHAR(128) parameter to specify the table for which you want to reset the identity value. If the owner of the table is not specified, tbl_name must uniquely identify a table in the database.

owner_name Use this optional CHAR(128) parameter to specify the owner of the table for which you want to reset the identity value. The default is NULL. If owner_name is not specified, then use a named parameter value for the third argument. For example:

CALL sa_reset_identity( 'Employees', new_identity=100 );

new_identity Use this optional BIGINT parameter to specify the value from which you want the autoincrementing to start. The default is NULL.

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.

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

You must be the owner of the table, or have the ALTER ANY TABLE system privilege.

Causes a checkpoint to occur after the value has been updated

The following statement resets the next identity value to 101:

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

sa_reset_identity system procedure

Syntax

Arguments

Remarks

Privileges

Side effects

See also

Example