CDB BDE main window

In the main CDB BDE window as shown in the following figure, you can:

  • Create, modify, and delete extensions
  • Create, modify, and delete relations or classes
  • Create, modify, and delete non-key properties of a relation or class
  • Add, modify, or remove key properties of a relation or class

When the window opens, all relations that belong to the current extension are listed. You can also display the classes associated with an extension.

image2020-10-23_12-21-14.png

The CDB BDE main window is divided into the following areas:

  • Top left pane—Lists the relations or classes for an extension, depending on the view that is selected.
  • Bottom left pane—Contains the Select View tabs that enable you to switch between relation and class views, and links for relation and class operations.
  • Top right pane—Lists the key properties and non-key properties of a relation or class.
  • Bottom right pane—Contains links for key property and non-key property operations.

Important

In the underlying RDBMS tables, columns are created in the same manner as the classes and relation properties in the CDB BDE. Key properties always precede non-key properties, but you can change the order of display within each category by sorting them in the top right pane. Select the property that you want to move and click the up or down arrow to move it in the list.

Related topic

Creating-and-managing-business-data-extensions

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*