sp_iq_reset_identity Procedure

Sets the seed of the Identity/Autoincrement column associated with the specified table to the specified value.

Syntax

sp_iq_reset_identity (table_name, table_owner, value)

Usage

You must specify table_name, table owner, and value.

Privileges

The user must be the table owner, or have ALTER permission on the table, or have the ALTER ANY TABLE or ALTER ANY OBJECT system privilege.

Description

The Identity/Autoincrement column stores a number that is automatically generated. The values generated are unique identifiers for incoming data. The values are sequential, are generated automatically, and are never reused, even when rows are deleted from the table. The seed value specified replaces the default seed value and persists across database shutdowns and failures.