Please show me the way to reset auto increment field in a table of the Advantage Database Server 11.0.
In SQL Server, it works like this:
DBCC CHECKIDENT ('tableName', RESEED, 0);
INSERT INTO TABLE1 (ID) VALUES (1);
the solution is to change a type of the identity column to INTEGER and set it back to AUTOINC after updates made.
ALTER TABLE mytable ALTER COLUMN auto auto INTEGER; INSERT INTO mytable SELECT * FROM myothertable; ALTER TABLE mytable ALTER COLUMN auto auto AUTOINC;
The solution was found at the Advantage Database forum.