Sets the seed of the Identity/Autoincrement column associated with the specified table to the specified value.
sp_iq_reset_identity ( table_name , table_owner , value )
Syntax You must specify table_name, table owner, and value.
None required.
The Identity/Autoincrement column stores a number that is automatically generated. These values 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 will persist across database shutdowns and failures.
The following example creates an Identity column with a starting seed of 50.:
CREATE TABLE mytable(c1 INT identity)
call sp_iq_reset_identity('mytable', 'dba', 50)
