Displaying tables

Displaying tables

Overview

Option D.2.1 provides information on all the tables defined in the definition file. It also enables you to display a list of all the fields and keys defined for a particular table. A key defines the order in which the fields of a table are sorted.

Procedure

  1. Select option D.2 from the "Service Manager Selection Menu" to display the "Dictionary Selection Menu".
  2. Select option 1 to call the "Display Database Tables" panel, which provides information on all the tables defined in the definition file.

    PEB5DI02 ------------------------------------------------------ Row 1 of 1
    Command ===> ________________________________________________ Scroll ===> PAGE

    Display Database Tables

    F - Display field definitions K - Display key definitions

    Sel Table Long Name Length Comment
    VC VC 00282 USER VC TABELLE
    ******************************** BOTTOM OF DATA ********************************













Columns

Column

Description

Table

Short name of the table

Table long name

Name of the table

Length

Length of the table in bytes

Comment

Brief description of the purpose of the table

Line commands

F

Display all fields assigned to a table.

K

Display all key assigned to a table.