reset identity in sql azure code example
Example 1: sql server reset identity
DBCC CHECKIDENT ('table name', RESEED , 0)
Example 2: reset identity column in sql server
DBCC CHECKIDENT ('YourTableName', RESEED, 1)
DBCC CHECKIDENT ('table name', RESEED , 0)
DBCC CHECKIDENT ('YourTableName', RESEED, 1)