|
Menu |
Toolbar |
Explorer |
Shortcut Key |
Shortcut Menu |
---|---|---|---|---|---|
Display/hide toolbars |
View, followed by the toolbar name |
n/a |
n/a |
<ALT + V>, followed by the letter for the appropriate toolbar name |
n/a |
Display/hide status bar |
Click on Tools > Options… |
n/a |
n/a |
<ALT + T>, then <P> |
n/a |
Create data model |
File > New |
Application toolbar: |
n/a |
<CTRL + N> or <ALT + F>, then <N> |
n/a |
Create title block |
Insert > Title Block |
Drawing Shapes toolbar: |
n/a |
<ALT + I>, then <B> |
Right-click on white space, Insert Title Block |
Edit title block |
Edit > Edit Title Block… |
n/a |
n/a |
<ALT + E>, then <E> |
Right-click on Title Block, Edit Title Block… |
Delete title block |
Edit > Delete Title Block |
n/a |
n/a |
<DELETE>
|
Right-click on Title Block, Delete Title Block |
Save / Save As |
File > Save or File > Save As |
Application toolbar: |
n/a |
<CTRL + S> or for Save As: <ALT + F>, then <A> |
n/a |
Close model |
File > Close |
n/a |
n/a |
<ALT + F>, then <C> |
n/a |
Open model |
File > Open |
Application toolbar: |
n/a |
<CTRL + O> or <ALT + F>, then <O> |
n/a |
Options |
Tools > Options |
n/a |
n/a |
<ALT + T>, then <P> |
n/a |
Colors and fonts |
Format > Colors & Fonts… |
Diagram toolbar: |
n/a |
<ALT + O>, then <C> |
Right-click on white space, Colors & Fonts… |
Create entity |
Insert > Entity |
Modeling toolbar: |
Right-click on Entities, New Entity… |
<ALT + I>, then <E> |
Right-click on white space, Insert Entity |
Create text block |
Insert > Text Block |
Drawing Shapes toolbar: |
n/a |
<ALT + I>, then <X> |
Right-click on white space, Insert > Text Block |
Edit entity |
Edit > Edit Entity… |
n/a |
Right-click on entity, Entities, Edit Entity… |
<ALT + E>, then <E> |
Right-click on entity, Edit Entity… |
Change entity name |
Edit > Edit Entity |
n/a |
Modify Name |
<ALT + E>, then <E> |
n/a |
Resize entity |
Format > Resize Entity/View |
n/a |
n/a |
<CTRL + R> |
n/a |
Copy entity |
Edit > Copy, then Edit > Paste |
Diagram toolbar: (copy), then (paste) |
Drag entities to the Data Model Window |
<CTRL + C> then <CTRL + V> or <ALT + E>, then <C> for copy, <ALT + E>, then <P> for paste |
Right-click entity, Copy, then right-click on white space, Paste |
Find entity option 1 |
Click on entity, Edit > Find Entity/View… |
Application toolbar: |
n/a |
<F4> |
Right-click on white space, Find Entity |
Find entity option 2 |
Application toolbar: |
n/a |
<CTRL + F> |
n/a |
|
Delete entity |
Edit > Delete Entity |
Diagram toolbar: |
Right-click on entity, Remove Entity |
<DELETE> |
Right-click on entity, Remove Entity |
Create submodel |
Model > Create Submodel… |
Right-click where submodel should be added |
<ALT + M>, then <C> |
Right-click on white space, Create Submodel… | |
Edit submodel |
Model > Edit Submodel… |
n/a |
Right-click on submodel, Edit Submodel… |
<ALT + M>, then <E> |
Right-click on white space, Edit Submodel… |
Delete submodel |
Edit > Delete Submodel |
n/a |
Right-click on submodel to delete and choose Delete Submodel |
<ALT + E>, then <D> |
n/a |
Create attribute |
Edit > Edit Entity… |
n/a |
Right-click on entity, New Attribute |
<ALT + E>, then <E> |
Right-click on entity, Edit Entity |
Edit attribute |
Edit > Edit Entity… |
n/a |
Right-click on entity, New Attribute |
<ALT + E>, then <E> |
Right-click on entity, Edit Entity |
Copy attribute |
Edit > Copy, then Edit > Paste |
Diagram toolbar: (copy), then (paste) |
Drag attributes to the Data Model Window |
<CTRL + C> then <CTRL + V> or <ALT + E>, then <C> for copy, <ALT + E>, then <P> for paste |
n/a |
Find attribute |
Tools > Universal Naming Utility |
Application toolbar: |
n/a |
<CTRL + F> |
n/a |
Delete attribute |
Edit > Delete Attribute |
Diagram toolbar: |
Right-click on attribute, Delete Attribute |
<DELETE> or <ALT + E>, then <D> |
n/a |
Create key |
Edit > Edit Entity… |
n/a |
Right-click on entity, New Attribute |
<ALT + E>, then <E> |
Right-click on entity, Edit Entity |
Edit key |
Edit > Edit Entity… |
n/a |
Right-click on entity, New Attribute |
<ALT + E>, then <E> |
Right-click on entity, Edit Entity |
Create relationship |
Insert > Relationship |
Modeling toolbar: |
Right-click on Relationships, New Relationship… |
<ALT + I>, then <R> |
Right-click on white space, Insert Relationship |
Create subtype |
Insert > Subtype Cluster > Complete or Incomplete |
Modeling toolbar: |
n/a |
n/a |
Right-click on white space, Insert > Subtype Cluster > Complete or Incomplete |
Find relationship |
Insert > Relationship Navigation |
Diagram toolbar: |
n/a |
<ALT + I>, then <G> |
n/a |
Delete relationship |
Edit > Remove Relationship |
n/a |
Right-click on relationship, Remove Relationship |
<DELETE> |
Right-click on relationship, Edit > Remove Relationship |
Generate physical data model (forward engineer) |
Model > Generate Physical Data Model… |
Application toolbar: |
Right-click on model, Generate Physical Data Model… |
<ALT + M>, then <G> |
n/a |
Generate physical data model (reverse engineer) |
Tools > Options |
n/a |
n/a |
<ALT + T>, then <P> |
n/a |
Datatype mapping editor |
Tools > Datatype Mapping Editor |
n/a |
n/a |
<ALT + T>, then choose Datatype Mapping Editor |
n/a |
Denormali-zation wizard |
n/a |
Modeling toolbar: |
n/a |
n/a |
Right-click on one of highlighted entities, Denormalization Mapping > Rollups or Rolldowns |
Create view |
Insert > View |
Modeling toolbar: |
Right-click on Views, New View… |
<ALT + I>, then <V> |
Right-click on white space, Insert View |
Connect view |
Insert > Relationship > View Relationship |
Modeling toolbar: |
n/a |
<ALT + I>, then <R>, then <V> |
Right-click on white space, Insert Relationship > View Relationship |
Edit view |
Click on view, Edit > Edit Database View… |
n/a |
Right-click on view, Edit > Edit Database View… |
Click on view, <ALT + E>, then <E> |
Right-click on view, Edit Database View… |
Create index |
Click on table, Edit > Edit Table… |
n/a |
Right-click on table, Edit Table… |
Click on table, <ALT + E>, then <E> |
Right-click on entity, Edit Table… |
Create horizontal partition |
Model > Denormalization Mapping > Horizontal Splits… |
Modeling toolbar: |
Right-click on table, Denormalization Mapping > Horizontal Splits… |
<ALT + M>, then <Z>, then <H> |
Right-click on entity, Denormalization Mapping > Horizontal Splits… |
Create vertical partition |
Click on table, Model > Denormalization Mapping > Vertical Splits… |
Modeling toolbar: |
Right-click on table, Denormalization Mapping > Vertical Splits… |
Click on table, <ALT + M>, then <Z>, then <V> |
Right-click on entity, Denormalization Mapping > Vertical Splits… |
Import data dictionary |
File > Import Data Dictionary |
n/a |
n/a |
<ALT + F>, then <Y> |
n/a |
Create new domain |
n/a |
n/a |
Right-click on Domains (or on a domain folder) then choose New Domain |
n/a |
n/a |
Create new user-defined datatype |
n/a |
n/a |
Right-click the User Datatypes node and then select New User Datatype… |
n/a |
n/a |
Create new reference value |
n/a |
n/a |
Right-click the Reference Values node and then select New Reference Value… |
n/a |
n/a |
Add attachment |
n/a |
n/a |
Right-click on the attachment type and select New Attachment… |
n/a |
n/a |
Create data movement rule |
n/a |
n/a |
Right-click the Data Flows node and then New Data Movement Rule |
n/a |
n/a |
Run macro |
n/a |
n/a |
Right-click on macro, Run Macro |
Right-click on macro, then <U> |
n/a |
Create macro |
Tools > Basic Macro Editor |
n/a |
Right-click on macro or macro folder, Add Macro… |
Right-click on macro or macro folder, then <A> or <ALT + T>, then <B> |
n/a |
Edit macro |
n/a |
Application toolbar:
|
Right-click on macro, Edit Macro… |
Right-click on macro, then <E> |
n/a |
Delete macro |
n/a |
n/a |
Right-click on macro, Delete Macro |
Right-click on macro, then <D> |
n/a |
Rename macro |
n/a |
n/a |
Right-click on macro, Rename Macro |
Right-click on macro, then <N> |
n/a |
Import |
File > New…, then Import Model From or File > Import File |
Application toolbar: |
n/a |
<ALT + F>, then <N> or <ALT + F>, then <M> |
n/a |
Export |
File > Export File |
n/a |
n/a |
<ALT + F>, then <F>
|
n/a |
Export image |
File > Export Image |
n/a |
n/a |
<ALT + F>, then <E> |
n/a |
|
Tools > Options |
n/a |
n/a |
<ALT + T>, then <P> |
n/a |
Report |
Tools > Generate Reports… |
Application toolbar: |
Right-click on model, Generate Reports… |
<ALT + T>, then <R> |
Right-click on white space, Generate Reports… |
Create internal naming standard |
Tools > Options |
n/a |
Right-click on Naming Standards Template, then New Naming Standards Template… |
n/a |
n/a |
Create external naming standard |
Tools > Naming Standards Template Editor |
n/a |
n/a |
n/a |
n/a |
Apply naming standards utility |
Model > Naming Standards Utility… |
Application toolbar: |
Right-click on model name, Naming Standards Utility… |
<ALT + M>, then <T> |
Right-click on white space, Naming Standards Utility… |
Compare/ merge |
Model > Compare and Merge Utility… |
Application toolbar: |
Right-click on source model (or submodel), Compare and Merge Utility… |
<ALT + M>, then <M> |
Right-click on white space, Compare and Merge Utility… |