To see all the columns in a table, put P. under the table name in the example table. All the columns shown in the example table appear.
When you run this query:
Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION | ------+----------+----------+---------+----------+----------| P. | | | | | | |
QMF produces this report:
DEPTNUMB DEPTNAME MANAGER DIVISION LOCATION -------- -------------- ------- ---------- ------------- 84 MOUNTAIN 290 WESTERN DENVER 66 PACIFIC 270 WESTERN SAN FRANCISCO 10 HEAD OFFICE 160 CORPORATE NEW YORK 15 NEW ENGLAND 50 EASTERN BOSTON 20 MID ATLANTIC 10 EASTERN WASHINGTON 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 42 GREAT LAKES 100 MIDWEST CHICAGO 51 PLAINS 140 MIDWEST DALLAS