[thelist] Auto Increment in database - a goofy question I am sure

[Anthony Baratta]

With MS SQL, I've just dropped the ID Field saved the changes, then added
the ID Field back in.

Another way is to clone the table structure, insert all the fields except
the ID field, drop/rename the olde table, and rename the new table to the
olde name.

Don't do this if of you are using the ID field as a foreign key in another
table!!
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."