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 partitioned tables : Creating partitioned tables without partition policies
Creating partitioned tables without partition policies
You can use the Add Table wizard to create a partitioned table (that does not have any partition policies defined on it) with local indexes defined on it. The connected database must be enabled for table partitioning.
To add a partitioned table to a connected OpenEdge database that is enabled for table partitioning:
1. Click Add table . The Add table icon is available 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. Enter a unique name in the Table Name field.
3. Select the Partitioned check box.
Note: The Partitioned check box is enabled only for databases that are enabled for table partitioning. The Area filed is disabled when you select the Partitioned check box, since partition areas are defined while defining partition rules.
4. Type a unique name in the Dump File field. This name can be up to 32 characters in length.
5. Optionally, enter information in the Label, Description, Validation, and Message fields. See OpenEdge Table wizard for more information about these fields and other options available on the wizard.
6. Select Next to display the Add Columns page. You must add at least one column to the table.
The Add Columns page enables 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.
7. Select Next to display the Add index page.
8. Enter a name for the index in the Name field. The name must be unique within the selected table.
9. Select Global or Local to specify the scope of the index.
Note: The index for a partitioned table without partition policies can be either global or local. When you select Local, the Area field is disabled, since partition areas are defined while defining partition rules. A local index cannot be a word index; so, when you select Local, the Word index option is disabled.
10. Specify the other index properties (see OpenEdge Index wizard for detailed information) and then select 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.