DMSQ TS FIELDS FULL (8029)    OPTION (19)

View in ViViaN Menu
Name Value
NAME DMSQ TS FIELDS FULL
MENU TEXT Field Listing by File (Full)
UPPERCASE MENU TEXT FIELD LISTING BY FILE (FULL)
ROUTINE EN^DMSQP2
DESCRIPTION
This can be used to see how the fields of a file or subfile were
if there are any subfiles associated with the file name that you entered,
there will be separate tables for them.  Use the option that shows
subfiles to get the numbers to use with this option.  That will let you
find all the columns associated with the files in a given file and its
subfiles.
projected as columns in a table.  It only shows regular columns.  It
doesn't include any Table_ID columns, ones automatically created
based on the internal entry numbers of the files and subfiles.  It also
doesn't show foreign keys, links that are automatically created when
there's a pointer or subfile connection.  (Other options can be used to
discover the names of foreign keys.)
 
Don't be surprised when the list of fields seems short.  Remember that
CREATOR USER,FIFTYFOUR
TYPE run routine