Reset Identity Column in SQL

Who is online?  0 guests and 1 members
Home  »  Blogs  »  BradSchacht  »  Reset Identity Column in SQL
sqlchicken likes this.
 
0
/5
Avg: 0/5: (0 votes)

Comments (2)

Daniel
Daniel said:
Blogging does help to set things into memory, but when the memory still fails the blog is your backup. ;-)
8/11/2011
 · 
 
by
user440082
user440082 said:
when the table is new, never used, then the current identity and increment values will be NULL. Thus, on a new table you will get ids starting from 0. After first usage, yes, if you re-execute this, will work fine.
6/25/2013
 · 
 
by
Blogs RSS Feed

BradSchacht's latest blog posts

Blogs RSS Feed

Latest community blog posts