阅读背景:

在删除行之后重用标识值

来源:互联网 

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 these rows, and then add five more, the new rows would have Ids: 6, 7, 8, 9, 10. Is it possible to let it start over at 1 again? Is it possible to reuse an identity field value




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: