When you select certain nodes in the DB Structure view, properties and values appear in the DB Details view.
When you right-click a node in the DB Structure view, a context menu appears that allows you to view schema; for OpenEdge databases, you can view, create, and edit schema. The context menu that appears is dependent on the type of database whose structure you are viewing and the node that is currently selected.
(For OpenEdge databases only) To convert tables in the OpenEdge database to multi-tenant tables, use the context menu Make Table Multi-tenant option . See Converting tables to multi-tenant tables.
The DB Structure view contains a toolbar button that launches the DB Structure Filters dialog. The DB Structure Filters dialog allows you to hide schema, catalogs, and table types. You can specify a delimited list of patterns to exclude or include. For example, you can enter C*, D* to display only those tables starting with c or d. To display those tables starting with the letters between A and F, enter [A-F]*.
You can also hide tables and columns based on a regular expression pattern. A regular expression is a mechanism for describing text patterns when executing the filter. These expressions are made up of ordinary characters.
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. A synonym is an alias that SQL statements can use instead of the name specified when the table, view, or synonym was created. 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 meta-schema tables. These tables cannot be altered. |
TABLE | Displays all application tables. Table nodes expand to show
columns and indexes.When you select a table name, data and meta-data
appear in the DB
Details view. Note: Since tables are
displayed in ASCII order and sorting is case-sensitive, all
lowercase table names are listed after the uppercase table
names.
|
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. |
Depending on which SQL-compliant database's structure you are viewing, the remaining nodes shown might vary.