KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Disabling the "Unique" Field Attribute Does Not Require an Index Rebuild
PRODUCT: 4D | VERSION: 19 | PLATFORM: Mac & Win
Published On: June 12, 2023

4D table fields have various attributes. One of the attributes is the "unique" attribute which specifies that the value of the specified field has to distinct across all records.

There are some scenarios in which the property needs to be disabled, such as a change in how the field is handled moving forward, or experiencing a duplicate values error that needs troubleshooting. When the "unique" attribute is disabled, the index does not need to be rebuilt, nor does the database need to be restarted because the attibute is dynamic and not stored in the index.