The unique constraints page lists unique constraints and primary key constraints from the database. Additionally, it is possible to create virtual unique constraints that do not represent a real object from the database but will act as such in Asmidio RDG.
If unique constraints are missing, it may be necessary to refresh the database metadata (shortcut F5
).
Note: Asmidio RDG will respect unique constraints at execution time, which means it will not try to insert duplicate rows according to those constraints. Since Asmidio RDG uses a memory-efficient, probabilistic data structure to do so, it is unlikely but possible that some insertions statements fail because of a unique constraint violation. In this case the the error will appears in the execution report but should not cause trouble since a number of failed statements is tolerated.