DB Table Editor

Purpose

In the DB table editor, you can edit the following elements clearly and conveniently.

• Database table with tables for table columns, keys, foreign keys, indexes, triggers
• Unique key with tables for 'Feature in the unique key'
• Foreign key with tables for 'Feature in the relationship key'
• Index with tables for 'Indexed table column'
• Database view with tables for columns, "From" clauses, triggers, "Subselect From" clauses and subselects for combined views

Call

You make the call by selecting Open from the context menu of the aforementioned elements.

All properties and labels of the element are displayed in the table.

Structure

The table for elements includes a specific Designribbon tab; you can use its commands to create and delete properties, among other things.

The document window tab indicates which element is displayed in the table.

The header area displays the name and type of model element which the properties and labels can be displayed for in the table as columns.

Fixed column splitter to the left in the column header to fix the columns to the left edge. Fixed columns are not moved if you click on the horizontal scroll bar.

Right-clicking on the column head opens a drop-down list where you can select the displayed properties.

Supported Procedures in the DB Table Editor

• Working in DB Table Editors

• Working in Table Editors for Elements