To add a multi-tenant table to a connected OpenEdge database using the schema
wizard:
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.
Type a unique name in the Table Name field.
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.
To associate the multi-tenant table with a storage area:
Select the Support default tenant check box (if
it is not already selected) to enable the Area
field.
Select a storage area from the drop-down list at the
Area field.
Note: 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.
Type a unique name in the Dump File field. This name can
be up to 32 characters in length.
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.
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.
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.