Notes and Regions are only for use in labeling and organizing entities in ER Models and are NOT included in the generated SQL when ER Models are scripted to DDL.
Notes are blocks of text that can be placed in an ER Model just like the other entities. There are four methods of creating a Note in the ER Modeler.
The font of a note's text can be altered by double-clicking the note and selecting a new font from the font dropdown at the top right of the Note Properties window.
Regions are labeled colored areas which sit behind entities in an ER Model and are used for grouping entities that need to be moved together. All of the contents of a Region shift with a Region when it is moved. There are three methods of creating a Region in the ER Modeler. Regions can be resized to hold more entities, and their colors can be changed. Regions do not appear in the Model Node Browser.
Any entities moved into a region after it is created become part of the region. The color and label of a region can be altered by double-clicking it and altering its properties in the Region Properties window. Right-clicking within a region and selecting Properties from the menu also allows editing the region color and label. Clicking on a region once selects it and all of its contained entities. This also highlights the contained entities in the Model Node Browser to show which entities are part of the region without having to zoom out in the sheet view to see them all. Clicking on a region once to select it, then again (but not double-clicking) selects only the region, but not its contents. Regions allow their text color to be altered with Foreground color selection.
The screenshot marked "Sample ER Model with Note and Region" displays an ER Model with a pink region, "Primary Tables", containing multiple tables, relationships, and notes. A note is currently highlighted in the sheet view for resizing, its handles and border easily visible. The Overview displays a red rectangle to show what portion of the ER Model the sheet view is zoomed, and how many table entities and relationships the pink region "Primary Tables" encompasses.
Sheet - Right-Click -
New Note
Notes Node - Right-Click -
New Note
Palette Entity Icon - Left Click -
New Note
Edit Menu - New Note
Note Properties Window
Sheet - Right-Click - New Region
Palette Entity Icon - Left Click -
New Region
Edit Menu - New Region
Region Properties Window
Sample ER Model
with Note and Region