SQL Azure Reset autoincrement

Question

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 !

possible duplicate of How to reset identity seed in Sql Azure — robert4
– robert4, Commented Apr 30, 2015 at 7:39

Yaroslav · Accepted Answer · 2012-07-25 07:54:06Z

6

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.

answered Jul 25, 2012 at 7:54

6,55210 gold badges54 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

The set identity_insert … on|off statements helped me out just fine, thanks!

Herve Roggero · Accepted Answer · 2012-07-25 16:40:46Z

You don't have too many options... the only one I can think of is to drop and recreate your table.