I found a lot of topics telling to use :
DBCC CHECKIDENT ('table', RESEED, 0)
But this is not supported by Azure SQL. Does somebody have any idea on how to do it easily ?
Thanks a lot !
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
DBCC CHECKIDENT is not supported for now in SQL Azure as you commented.
Check this MSDN forum post, there are some solutions proposals, maybe one of them can help you out.
回答2:
You don't have too many options... the only one I can think of is to drop and recreate your table.
