Try OpenEdge Now
skip to main content
Managing Table Partitioning in Databases
Managing Table Partitioning in a Database : Creating a table partition : Viewing and editing a table partition policy

Viewing and editing a table partition policy

After you set up a table partition policy, you can view its details in the Table Partition Policies page.
To view or edit a table partition policy:
1. Ensure that the database server is running and that you have set up the database connection.
2. Select Database Administration > Database Connections. The list of database connections appears in the list frame on the left.
3. Click the database connection whose contents you want to view. The database home page options appear in the details frame on the right.
The frame displays the Connections option, which allows you to return to the list of connections if you want to select a different database.
4. In the Database Connection Details page on the right, scroll down to the Storage Management section and click Partition policies to view all the configured partition policies in the database. In the Table Partition Policies page that appears, you can view the list of partition policies that appear in the list frame.
5. Click on the required partition policies from the Partition Policy Name column. The Edit Table Partition Policy page appears.
6. View and edit the table partition policy as per your requirements.
Note: For information about the fields in the table partition policy area, refer to Creating a table partition policy. The Has composite partition setting shows whether the table partition policy has composite partitions.
7. Click:
*Edit Detail to edit the partition policy details.
For information about the fields in the partition policy details area, refer to Editing table partition policy details.
*Commit to update the partition policy with the new edits.
*Generate policy program to generate OpenEdge ABL code (.p) that you can use in OpenEdge ABL programs to create a table partition policy with all the defined partition policy details. Note that generating the policy program only generates the policy program with the newly made edits; you must click Commit for the newly made partition policy updates to reflect in the database.
Note: To sort the information in the grid, click a column name to sort the column values in ascending or descending order. If you have a large number of policies, you can also move forward or backward a page, or specify a particular page, in the list of policies by using the Page feature at the bottom of the list; or, you can filter the list of partition policies by entering the policy name in the Search field.