
Writing
MSSQL–Reset Identity seed
DBCC CHECKIDENT resets an identity seed to a chosen value. A table example explains why the reseed value precedes the desired next identifier after test data is deleted.

Topic
Microsoft SQL Server databases, including SQL commands, storage features, administration, and application integration.
1 page

Writing
DBCC CHECKIDENT resets an identity seed to a chosen value. A table example explains why the reseed value precedes the desired next identifier after test data is deleted.