Applying Table Per Class Hierarchy Strategy

In order to apply this kind of strategy, you should set transformation type of the root class to Generate table and the transformation type of other classes in the class hierarchy to Migrate column.

For each class hierarchy, a discriminator is needed to distinguish between different class instances. You need to select one of the attributes of the root class in the Specifying Attribute list located in the property sheet of one of the children inheritance links of the root class. The attribute will be transformed into a discriminator column. In the following example, we define one extra attribute shapeType in Shape and select it as discriminator attribute:



The generated table will look like the following:




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