Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Working with OpenEdge databases : Viewing and maintaining OpenEdge database schema : Working with multi-tenant tables : Adding multi-tenant tables
 
Adding multi-tenant tables
To add a multi-tenant table to a connected OpenEdge database using the schema wizard:
1. Click Add table . The Add table icon is on the context menu when either the TABLE node or an individual table node is selected in the DB Structure view. It is also available as a toolbar icon on the OpenEdge Table tab of the DB Details view.
2. Type a unique name in the Table Name field.
3. Select the Multi-tenant check box.
Note: The Multi-tenant check box is unchecked and disabled when you try to add a table for database that is not enabled for multitenancy; it is unchecked and enabled when you try to add a shared table.
4. To associate the multi-tenant table with a storage area:
a. Select the Support default tenant check box (if it is not already selected) to enable the Area field.
b. Select a storage area from the drop-down list at the Area field.
The Support default tenant option is automatically selected when you select the Multi-tenant check box. When you clear the Support default tenant check box, the Area field gets disabled.
5. Type a unique name in the Dump File field. This name can be up to 32 characters in length.
6. Optionally enter information in the Label, Description, Validation, and Message fields. See Add Table wizard for more information about these fields and other options available on the wizard.
7. Select Next to open the Add Columns wizard.You must add at least one column to the table. The Add Columns dialog allows you to either copy columns from other tables or create a new column.
Note: When you copy a column, you copy only the column schema. You do not copy data.
8. Select Next to add an index or Finish to complete the table and add it to the database.
Note: Since tables are displayed in ASCII order and sorting is case-sensitive, all lowercase table names are listed after the uppercase table names.