The Table wizard allows you to specify table properties for OpenEdge databases. You use the wizard to specify the properties of a new table or to change the properties of an existing table.

Start the Table wizard by clicking Add Table or Edit Table . Both are available from context menus in the DB Structure view and from the OpenEdge Table tab of the OpenEdge DB Details view.

The Table wizard allows you to specify or change the following properties:

Table Name Specifies a table name that is unique within the database. Table names must follow these conventions:
  • A table name can be up to 32 characters long.
  • A table name can consist of alphabetic characters (A-Z or a-z), digits (0-9), and the pound sign (#), dollar sign ($), percent sign (%), ampersand (&), hyphen (-), and underscore (_). In addition, names must begin with a character (A-Z or a-z).
  • You cannot use reserved ABL keywords as names.
  • Names are not case-sensitive; they can be uppercase, lowercase, or a combination of both.
Partitioned Creates a partitioned table without any partition policies defined on it.
Note: The Partitioned option is enabled only if the selected database is enabled for table partitioning. It is disabled if the Multi-tenant option is selected, since a table cannot be both multi-tenant and partitioned.
Multi-tenant Creates a multi-tenant table.
Support default tenant Allows you to associate a multi-tenant table with a storage area.
Area Specifies the storage area from a list of storage areas defined for the database.
Note: The Area field is disabled if the Support default tenant check box is cleared while creating a multi-tenant table. The Area filed is also disabled when you select the Partitioned check box, since partition areas are defined while defining partition rules.
Dump File Specifies a unique filename for dumping table contents or definitions.
Label Specifies the label that is used in error messages. This field is followed by a Field string attributes field for controlling text preferences and space allocation.
Description Describes the contents or purpose of the table for documentation purposes.
Validation Defines what criteria to apply before row deletion is allowed. For example, in a customer table, to restrict deleting customers to those who have no outstanding orders, NOT (CAN-FIND(FIRST order OF customer))
Message Specifies an error message that is displayed when a record deletion is invalid. This field is followed by a Field string attributes field for controlling text preferences and space allocation.
Category Specifies the category of the OpenEdge tables to be displayed in the OpenEdge DB Structure view view. You can specify a category from the existing list or create a new one.
Hidden Creates hidden tables.
Keep wizard open after adding table Keeps the wizard open to add one or more other tables.