Type inheritance

Type inheritance applies to named row types only. You can use inheritance to group named row types into a type hierarchy in which each subtype inherits the representation (data fields) and the behavior (UDRs, aggregates, and operators) of the supertype under which it is defined. A type hierarchy provides the following advantages:

• It encourages modular implementation of your data model.
• It ensures consistent reuse of schema components.
• It ensures that no data fields are accidentally left out.
• It allows a type to inherit UDRs that are defined on another data type.