Resetting an Auto increment field

[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

[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.