Naming Rules on MySQL
The syntax for index names is TableName_IDX
Number where Number is the number of the index.
The following rules apply:
-
Letters, numbers, dollar signs ($), and underscores (_) are allowed, but the first character must be a letter.
-
Uniface only accepts uppercase names in the application model definition.
-
You are not allowed to use any of the MySQL reserved words for the names of entities or fields. These reserved words are listed in the MySQL documentation. Table names must also comply with Uniface rules.
-
The same rules apply to field names as for tables.