Can I control auto generated column in MSSQL?

Question

I want to control auto generated column in MS SQL dtatabase.

For example: If I delete number '2', next time I add the role and the id of this role becomes '3'. I want to be the id of added role to be '2'.

Is there any way to solve this? Thanks a lot for viewing my question.

Praveen Kumar Sreeram · Answer

Hi you need to use the following command DBCCCHECKIDENT( '[TestTable]' RESEED0); For more information please have a look athttps://msdn.microsoft.com/en-IN/library/ms176057.aspx Hope it helps Thanks Prawin