How to change the current value of an auto increment field? Is it possible without dropping the table? Yes it is possible. In order to do that you have to use SQL command called DBCC CHECKIDENT Following is the syntax of the DBCC CHECKIDENT command. DBCC CHECKIDENT ( <table_name> [ , { NORESEED | { …