The figure summarizes the options for ALTER TYPE INVALIDATE and their effects.
The illustration is divided into three sections:
- Section 1 - Alter Type Invalidate - Target type
Type T1 is in this portion of the illustration.
- Section 2 - Cascade Not Including Table Data - Dependent types
Dependent type T2 is in this portion of the illustration, plus the metadata of dependent tables.
- Section 3 - Cascade Including Table Data - Dependent tables
Other dependent objects D1 and D2 are in this portion of the illustration, plus dependent tables TB1 and TB2 that contain the types T1 and T2 respectively.
The options for each section of the illustration are described under the heading "Notes on the figure:" in the text.