Question

How unique is an object id?

3

Is the automatically generated Id unique over different entities? If a record is deleted from a table, is it possible that a new record gets the deleted id?

asked 2016-12-21

Pieter Scherphof

1 answers

Marcel Groeneweg ITV · Accepted Answer · 2016-12-22

It is unique across the database, so across all entities.

No you will always get a unique ID. No reuse of IDs.

If you were to restore a database, for example to your laptop, be sure to either clean your local database during the restore or drop it entirely. I always drop it and create it fresh before the restore. If you just restore it over existing database objects, you have a big chance on duplicate IDs and far worse issues. A restore in the Mendix cloud takes care of this for you.