simple database question

Results 1 to 2 of 2

Thread: simple database question

  1. #1
    vecna Guest

    Default simple database question

    i was wondering how you can reset the autonumber in a table back to realign information, like lets say if the numbers are<BR>1, 2, 3, 4 , 8, 9, 10,<BR>i would like to shift the table autonumbers so they will change to:<BR>1, 2, 3, 4, 5, 6, 7,<BR>how do i do that

  2. #2
    Join Date
    Dec 1969

    Default RE: simple database question

    you can&#039t - hence the name &#039AUTO&#039number. <BR><BR>BUT, if you wish to recreate the numbering, you can always drop and recreate the table if its&#039 a necessity. OR, you could create another attribute labeled &#039index&#039 that you can manually intervene with.<BR><BR>hope that helps!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts