Displaying Database Names and Structures › KEY DISPLAY

KEY DISPLAY

If you want to know the names of keys (in DQL Mode) for a table, you press the DISPLAY KEYS PF key to see this panel:

Sample KEY DISPLAY (DQB50)

 =>
 PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY.
 --------------------------------------------------------------------------DQB50
 DATAQUERY:  KEY DISPLAY                       DICTIONARY DATABASE ID: 189
 -------------------------------------------------------------------------------
  TABLE NAME:  PERSONNEL                          DB NAME:  PMF    DB ID:  001
 -------------------------------------------------------------------------------
   KEY NAME                              |           DESCRIPTION
       COLUMN NAMES                      |
 -------------------------------------------------------------------------------
   NUMBER                                | EMPLOYEE NUMBER KEY
       NUMBER                            | EMPLOYEE NUMBER
   STATE-ZIP                             | EMPLOYEE STATE ZIP KEY
       STATE-ADDRESS                     | EMPLOYEE STATE CODE
       ZIP-CODE-LOC                      | EMPLOYEE ZIP CODE
                                         |
                                         |
                                         |
                                         |
                                         |
                                         |
 - LAST PAGE -------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN     <PF3> DISPLAY COLUMNS <PF4> NOT USED
 <PF5> EXTENDED DEFN  <PF6>  TEXT       <PF7> BACKWARD        <PF8> FORWARD

All column names are indented following the name of the key to which they belong. Notice that the key named NUMBER consists of only one column, while the STATE-ZIP key consists of two columns. The high-order column in a key is the column listed first.