>I have noticed that when I zap a table with an autoincrement field, it does not reset the value of the autoincrement field. Is there a way to reset this, other than making a new copy of the table?

ZAP
ALTER table mytable ALTER COLUMN PK I AUTOINC