1 Replies - 1319 Views - Last Post: 28 September 2017 - 02:57 PM

#1 aplusdesigners  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 48
  • Joined: 09-June 14

AutoNumber Issue

Posted 28 September 2017 - 02:54 PM

So, I have a table that I accidentally forget to set to AutoNumber before I entered my first line of data. Now for some reason, after changing to AutoNumber, it wants to start the number at 2. Is there a way to rest the numbering after data has been entered without deleting and starting over?

TIA!

Lee
Is This A Good Question/Topic? 0
  • +

Replies To: AutoNumber Issue

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13400
  • View blog
  • Posts: 53,479
  • Joined: 12-June 08

Re: AutoNumber Issue

Posted 28 September 2017 - 02:57 PM

Probably want to clear the autoincrement, and set the 'reseed' to 0.
https://docs.microso...nt-transact-sql
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1