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

Print

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…