possible to reuse an identity filed value after deleting row

Oct 6 2015 9:41 AM

Is it possible to reuse an identity field value after deleting rows in SQL Server 2008 Express? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. If I were to delete 3 number row, and then add two more, the new rows would have Ids: 6, 7 . Is it possible add new row place of deleted row with same id.

Answers (2)

Create table in SQL Server 2008R2

Insert Data Into Parent And Then Child Tables