or Edit Table
. Both are available from context menus in the DB Structure view and from the OpenEdge Table tab of the DB Details view.
|
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 Attribute 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 Attribute field for controlling text preferences and space allocation.
|
|
Category
|
Specifies the category of the OpenEdge tables to be displayed in the DB structure 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.
|