Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Reset identity seed for a table (See related posts)

This SQL query will reset an identity seed to the specified value.

Thanks to this site for the answer:

http://www.thescripts.com/forum/thread657059.html

I know this works for MSSQL 2000 at least :)

DBCC CHECKIDENT('mytable', RESEED, 0) ;
to sql reset microsoft column transact reseed seed identity ident field ms dbcc checkident by chrelad on Fri Nov 16 16:04:35 +0000 2007

You need to create an account or log in to post comments to this site.


Related Posts