I empty tables here and there and I would like to reset the AutoInc counter.
How do I do that?

andrej


The easy way - go into DBSys, select alter table and alter the last autoinc value. Slightly more difficult in code (you have to do some typing) its part of the ALTER TABLE statement eg

ALTER TABLE fred LAST AUTOINC 0;

But check it out in the OLH cos its a long time since I've done this.

Roy Lambert [Team Elevate]