
Chapter 7 Denormalizing a PDM
Managing vertical partitions
You can manage partitions from the Partitions page of the property sheet of a vertical partitioning object. The following actions can be performed:
- Open the property sheets of the tables corresponding to the partitions. You can modify the properties of the table from the property sheet. If you modify the name or the code of the table, the name or code of the corresponding partition is automatically updated
- Add more partitions and define the properties of their corresponding tables
- Delete one or several partitions and their corresponding tables. When you delete a partition, a message box appears to ask you if you want to delete the corresponding table. You can delete a partition and keep the corresponding table, however you cannot delete a table and keep an orphan partition
The Partition Columns page lets you move columns between partition tables. You can drag and drop columns from one partition table to another.
You cannot move or paste a vertical partitioning object into another model or package.
Copyright (C) 2005. Sybase Inc. All rights reserved.
|
|