Autonumber PK

[Guest]

How do I change an PK Auto numeric field to 0 in a Table?

Many thanks

 

[Norman Yuan]

The table in which type of database? "Autonumber" implies thePK is generated
by the database AUTOMATICALLY (to guarantee its uniqueness), so, no, you
cannot change it, and no need to change it. OTOH, if you feel the need for
the PK to have certain value, then you should not use "Autonumber" at all.

 

[Kedar]

SET IDENTITY INSSERT ON
THEN UPDATE TABLE XXX SET YYY=ZZZ WHERE XYZ