Identity Seed

Identity Seed

Post by John M. Sn » Thu, 12 Feb 2004 01:39:54


Is there a way using T-SQL (or any other way) to change
the "Identity Seed" value of a field in a table.
 
 
 

Identity Seed

Post by Paul Ibiso » Thu, 12 Feb 2004 05:24:36

DBCC CHECKIDENT,
eg
USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 30)
GO
Regards,
Paul Ibison