Hi all,
Does anyone know how this works? For some reason when changing package dependencies, the autonumbering was switched off.
Now I can't find a way to to switch it back on and continue at the numbering it was at. The only option seems to start from the beginning?
Thanks
Harry
Like
Hi Harry,
We understand that you may need to manually reset the current number in a specific column, for instance, to initiate numbering from 1. Currently, there is no interface that allows users to configure this manually, so the following steps need to be taken:
Identify the UId of the auto-numbered column.
For the identified column, use the script below to set a new starting number. In the examples provided, '4a40180c-61bf-de86-2f08-b05852a5ea6d' represents the UId of the auto-numbered column, and '1' is the next value from which the auto-numbering will proceed.
Script for MSSQL:
ALTER SEQUENCE [4a40180c-61bf-de86-2f08-b05852a5ea6d]
RESTART WITH 1;
Script for PostgreSQL:
SELECT setval('4a40180c-61bf-de86-2f08-b05852a5ea6d', 1, false);