Indexes and table relations are two database structure elements that are frequently left up to 4D to maintain their uniqueness among other structure elements. However, with a little discipline, developers can implement a naming convention for their indexes and relations that will make it easier for them to read and maintain. Names can be more descriptive than the UUIDs generated for these objects from 4D. They can convey information such as index type and how they are used. Users can quickly read this information which can save them hours of staring at the Structure Editor trying to find a specific index or relation. And it can be easier to write readable code to access these objects with the System Tables.

Download Complete Tech Note: Windows | Mac