Is there any way to reset the autonumber in a table.
The situation is this, I've been creating a database (Duh) and Ive been filling the table with test information, now that all the bugs have been whacked out of the system, i want to reset all the tables to 1.
Help