INDEXINF primary command
The INDEXINF primary command shows or hides index information about each column when displayed in SNGL display format.
In SNGL display format, FM/Db2 displays an additional column (to the left of the column containing the column name) showing information about primary keys, foreign keys, unique indexes. (If you enter the INDEXINF primary command in TABL display format, the display is unaltered. However, if you change to SNGL display format, the display status of the additional column is reversed.)
If the index information is already displayed, the INDEXINF primary command removes it from display.
Note:
- Information about primary keys, foreign keys, and unique indexes is only shown for tables (but not for views).
- Foreign key information can only be displayed if the Retrieve foreign key information when building templates option is selected when the template is created.
- The INDEXINF primary command has the same effect as selecting (or deselecting) the Show keys, indexes option.