Page 1 of 1

Resetting an Auto increment field

Posted: Fri 23 Dec 2011 16:29
by JamesBrown
Is it possible to get a 'do over' on the autoincrement field of a table?

After having trouble importing data into a table and doing it over and over the field became very large. I would like to reset it before releasing it.

Thanks......... Jim

Posted: Mon 26 Dec 2011 09:05
by alexa
Hello, Jim.

We suggest you to do the following:

1. Right-click the table in Database Explorer and select 'Edit Table' from the popup menu.
2. Switch to the 'Options' tab.
3. Modify the value of the 'Auto increment' field
4. Save the table's changes.