Previous Topic: DIRECTORY - Display Directory Selection PanelNext Topic: DRAW - Create a Simple Query


DISPLAY - Display Keys and Columns

Purpose

Entering the DISPLAY command followed by a database table name you are authorized to access displays the Key and Columns Display panel for that table. See Panels for details about using the Key and Columns Display panel.

When to Use It

If you need to know about the keys and columns in any production status database table, or see the definition of any key or column.

Syntax

Enter

With

When You Want to:

DISPLAY

table-name

See a list and description of each key and column for the production status table you name.

DISPLAY

No operand

Display the Display Command prompt panel to see command syntax or see a list of tables you can access.

Example

=> DISPLAY CREATION PANEL ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: ________________________________ ----------------------------------------------------------------------------- NAME: _______________ TYPE: QUERY STATUS: PRIVATE DESCRIPTION: ___________________________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== ..

Result

=> ------------------------------------------------------------------------DQB00 DATAQUERY: DISPLAY COMMAND DISPLAY ________________________________ (1) ----------------------------------------------------------------------------- (1) Enter the name of a table and press <Enter> to display its keys and columns. Press <PF3> for a list of tables. ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> LIST TABLES