OpenEdge DB Details view

The DB Details view is a read-only display of information specific to the selected node in the DB Structure view.
Note: This detailed view is available only for certain nodes. If the detailed view is not available for a node you select in the DB Structure view, no information appears in the DB Details view.
The content of the DB Details view changes depending on which node you select in the DB Structure view. There are two top-level nodes: Database and Security.

Database

When you select a child of one of the nodes listed in the left column of the following table, the corresponding information appears in the DB Details view:

SYSTEM TABLE or TABLE For a child node, displays details about the following:
  • Columns - A list of all columns and related SQL information.
  • Indexes - A list of indexes in the selected table.
  • Primary key - A list of the primary keys defined for the selected table. This is relevant only to tables created through SQL, although it will display the components of the OpenEdge primary key.
  • Foreign key - A list of any foreign key restraints defined for a selected SQL table.
  • Preview -A subset of the records in the selected table. You can set the number of rows returned in the Preferences page.
  • Row count - The total number of rows in the selected table.
    Note: If you have an OpenEdge database table that contains many records (over a million, for example), it is not advisable to select this panel. Since OpenEdge manually counts the records, which can take a long time, the system appears to freeze.
  • Privileges - A list of both table and column privileges (as a toggle).
  • Partition Key - A list of partition key attributes in the selected database table.
  • OpenEdge Table - A list of table attributes. Attributes are extracted from the _File system table.
    Note: The Area and Can-* fields are available only for users who have DBA privileges.
  • OpenEdge Columns - A list of column attributes. Attributes are extracted from the _Field system table. The columns can be sorted in ascending or descending order by clicking the Name label.
  • OpenEdge Indexes - A list of index attributes.
VIEW For a child node, displays view properties, which are column name, data type, size, decimal, default value, accept null value, and comments.
SEQUENCES For a child node, displays the properties of the sequence, including its current value.
TRIGGERS For a child node, displays details for a trigger, including Trigger Type, Table, Column, Event, Procedure, Overridable, and Check CRC.
DB DETAILS Displays database properties under the Database tab. Under the Tables & Columns tab, it displays all columns from all tables and their properties sorted by table and column names. You can sort the table names in ascending or descending order by clicking the Column label.

Security

When you select the Security node, the DB Details view displays the Security tab. The Security tab displays information from the _Users and the _Sysdbauth tables regarding user accounts and privileges. You can manage user accounts from the icons on the Security tab in the DB Details view. For multi-tenant tables in the OpenEdge database, the Security tab displays information from the _Tenant table. This information includes the tenant name, domain name, and the type of user.