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 appears as a tree view and begins with the root node Database. Depending on the particular SQL-compliant database you are working with, the nodes that appear in the tree view might be different.

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 DB Structure Filters dialog also allows you to select the category of tables that you want to view in the DB Structure view. You can either choose from a list of existing categories or create a new one.

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.