Partitions (PDM)

A partition is a physical division of the contents of a database table, created to improve manageability and performance.

You can create as many partitions as necessary in a table.

Note: If you associate a table with a lifecycle (see Lifecycles (PDM)), PowerDesigner will delete all existing table partitions in order to create the necessary partitions to move data between lifecycle phases.

Creating a Partition
You create partitions on the Partitions tab of a table using the Insert Row and Add a Row tools.
Partition Properties
You can modify an object's properties from its property sheet. To open a partition property sheet, double-click its Browser entry, or select it on the Partitions tab of a table property sheet and click the Properties tool.

Parent topic: Building a Physical Implementation

Created October 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com