0

I created a table Tbl_Category with an identity column (2001,1) and inserted four records into the table. Up to four rows, it worked fine, when I'm trying to insert a 5th row now, the identity column jumps to a value of 3005. The identity column (3001,1) was assigned to another table Tbl_Subcategory in the same database.

Table structure:

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Manikanth Boppudi
  • 1
  • 4
  • 1
    see this http://stackoverflow.com/a/14146237/3540365 – A_Sk Sep 21 '16 at 05:55
  • 1
    Note: if, for whatever reason, you _really_ needed to reset the identity to a certain value you could use something like `dbcc checkident('myTable', reseed, X)` where X is the number you wish to reset to. – ZLK Sep 21 '16 at 05:57

1 Answers1

0

Well you can go into the table by right clicking on it and then pressing Design. Then in there mark the row you want to remove the identity from and at the bottom of your screen look for "Identity Specification". Then click that and double click to change the "Yes" to a "No".

Danieboy
  • 4,393
  • 6
  • 32
  • 57