If you want to reset identity value, just execute this command
declare @tableName varchar(100) = 'tableName'; declare @value int = 0; DBCC CHECKIDENT (tableName , reseed, @value)
The next value will be 1, but you can choose any natural number.
Web development, dotNet and other stuff
by piotrdev · June 9, 2015
If you want to reset identity value, just execute this command
declare @tableName varchar(100) = 'tableName'; declare @value int = 0; DBCC CHECKIDENT (tableName , reseed, @value)
The next value will be 1, but you can choose any natural number.
Tags: TSQL
27 Nov, 2015
24 Nov, 2014