Online Help | Desktop App

Working with user-defined fields

In addition to system fields available by default in various Alloy Navigator tables, you can add new fields. These fields are called user-defined fields, or UDFs.

See the following sections for instructions:

Total size limit

Microsoft SQL Server has a row size limitation, and so the total size of all object’s fields (both standard and user-defined) cannot exceed the predefined limit. That’s why we recommend that you pay attention when adding UDFs, especially of the String type, which are longer than the others. If the combined size of all fields exceeds the limit, you will receive a warning message advising you to reduce the size of the field you are adding or reduce the combined size of all UDFs. If you ignore the advice, a data loss may occur.