query?

[Ravi Shankar43]

I have a three columns in which one column is auto generated by increment 1. if i delete one record from the table (example:4 record i deleted)it should be updated as 5th record as 4th record and so on?

[Colin Angus Mackay]

Ravi Shankar43 wrote:

I have a three columns in which one column is auto generated by increment 1. if i delete one record from the table (example:4 record i deleted)it should be updated as 5th record as 4th record and so on?

No. If you delete rows the number that was autogenerated for that row will not be reused.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Frank Kerrigan]

You can reseed the indentity if you are trying to hide something, but it could mess up your db schema

---

Blog Have I http:\\www.frankkerrigan.com