Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : OpenEdge database : OpenEdge DB Structure view
 
OpenEdge DB Structure view
When you open a connection in the Connections view, the schema for the database appears in the DB Structure view. The DB Structure view is a tree view that shows a separate structure for each schema under the root node Database. Depending on the database, the root and other nodes that appear in the tree view might be different.
Note: You can configure DB Navigator to display or hide schemas. By default, catalogs are displayed while schemas are hidden from view. See DB Navigator preferences for more information.
When you select certain nodes in the DB Structure view, properties and values appear in the DB Details view.
The top-level nodes in the OpenEdge DB Structure view are Database and Security. You can use context menus to work with the schema, and you can use filters to show only certain schema items in the view.
Database
The root node Database is at the top level of the DB Structure view. If the database supports catalogs and you have selected Show catalog in the DB Navigator preferences, all catalogs appear below the database node. If you have selected Show schema in the DB Navigator preferences, all schemas appear below the database node.
Beneath the schema and catalog nodes, the following child nodes appear:
SYNONYM
These SQL elements display all synonyms that were created in SQL against tables. The child nodes contain only tables, views, or other synonyms. They do not display columns or indexes of the tables.
SYSTEM TABLE
Displays virtual systems tables and other metaschema tables. These tables cannot be altered.
TABLE
Displays all application tables. Table nodes expand to show columns, indexes, and triggers.
Note: Since tables are displayed in ASCII order and sorting is case-sensitive, all lowercase table names are listed after the uppercase table names.
This node also displays the multi-tenant tables associated with the OpenEdge database. A multi-tenant decorator ( ) which is displayed with each multi-tenant table indicates that it is multi-tenant table.
VIEW
Displays the names of all created views. A SQL view allows you to extract rows and columns from one or more related tables and to treat the resulting data set as a table that can be viewed or updated.
SEQUENCES
Displays sequences in alphabetical order. A sequence is an incremented number series applied to a particular field (column). Whenever a new record (row) is created, the number is incremented based on the value in the previous record.
TRIGGERS
Displays ABL schema triggers, replication triggers, and Java triggers.
DB DETAILS
Displays database, table, and column properties in the DB Details view.
Security
When you select the Security node in the DB Structure view, a list of user accounts appears in the DB Details view. You can manage user accounts from the icons on the Security tab in the DB Details view.