Index mandatory for unique fields

Home

4D v15

Originally introduced in 4D v14 R4

In 4D, fields with the Unique attribute must be indexed. In the Structure editor, you are no longer able to define fields with a Unique attribute if they do not have an index. In previous releases, it was still possible to obtain such a configuration for maintenance purposes.

The Structure editor has been updated:

It visually indicates that an index will be created (if it does not already exist) when you select the Unique attribute for a field:

It prevents you from removing the index of a Unique field (None or remove options are not available for indexes when such a field is selected):

If you want to remove the index from a Unique field, you need to remove the Unique attribute beforehand.