Back to Bookshelf

• Help and Web Title Page
• Legal Notices
• CA Technologies Product References
• Documentation Changes
• Contact CA Technologies
• Obtain a License
• Release Numbering Scheme in CA ERwin Data Modeler
• What's New
  • New Reporting Tool--Report Designer
    • Report Designer Features
  • Metadata Integration Bridges Updated
  • Teradata Support Enhancement
• Community Edition
• Sample Model
• Design Layer Modeling
• The Text Editor
• CA ERwin Data Modeler User Interface
  • The Data Modeling Workspace
    • The CA ERwin Data Modeler Workspace
      • The Standard Toolbar
      • The Toolbox Toolbar
      • The Formatting Toolbar
      • The Layout Toolbar
      • The Display Toolbar
      • Mart Toolbar
      • The Database Toolbar
      • The Alignment Toolbar
      • The Drawing Toolbar
      • The Transformations Toolbar
      • Customize a Toolbar
      • Create a Toolbar
      • Move a Toolbar
      • The Status Bar
      • Summary of On-Diagram Editing
      • Shortcut Menus
      • r9 Menu Layout Compared to r8.x
    • The Diagram Window
      • Auto Hide a Workplace Pane
      • Changing the Diagram Window Magnification Level
    • Logical and Physical Modeling
      • Model Types
      • The Logical Model
      • The Physical Model
      • Logical and Physical Objects
      • Comparison of Logical and Physical Models
      • Switch Between Logical and Physical Models
      • Comparison of Logical and Physical Model Objects
      • Logical and Physical Model Denormalization
      • How to Resolve Many-to-Many Relationships
      • Add a User-Defined Property to a Physical Object
      • Add a User-Defined Property to a Logical Object
    • Logical and Physical Modeling Notation
      • IDEF1X Logical Model Tools
      • IDEF1X Physical Model Tools
      • IE Logical Model Tools
      • IE Physical Model Tools
      • DM Physical Model Tools
    • Global Default Options
      • Set General Options
      • Set Default XML Options
      • Set Default Diagnostic Options
      • Start or Stop the ERwin ODBC Driver
      • Set Default Actions for a Three-Way Merge
      • Generate Diagnostic Export
  • The Model Explorer
    • How the Model Explorer Works
      • Display or Hide the Model Explorer Pane
      • Float the Model Explorer Pane in the Main Window
      • Dock the Model Explorer Pane
      • Resize the Model Explorer
      • How the Cursor Behaves in the Model Explorer
      • Drag Model Objects within the Model Explorer
      • Drag Model Objects from the Model Explorer to the Diagram Window
    • Drag Model Objects within the Model Explorer
    • Drag Model Objects from the Model Explorer to the Diagram Window
    • Model Explorer Model View
    • Model Explorer Subject Area View
      • Include an Entity as a Member of a Subject Area using the Model Explorer
      • Include a Table as a Member of a Subject Area using the Model Explorer
      • Include a View as a Member of a Subject Area using the Model Explorer
      • Include a Materialized View as a Member of a Subject Area Using the Model Explorer
    • Customize the Model Explorer Display of Logical Object Names
    • Customize the Model Explorer Display of Physical Object Names
    • Identify Model Sources in the Model Explorer
    • Modify Object Properties Using the Model Explorer
    • Rename an Object in the Model Explorer
    • Add a Physical Storage Object Using the Model Explorer
    • Move an Attribute Using the Model Explorer
    • Move a Column Using the Model Explorer
    • Copy an Object Using the Model Explorer
    • Sort Domains in the Model Explorer
    • Select Multiple, Consecutive Objects in the Model Explorer
    • Select Multiple, Non-consecutive Objects in the Model Explorer
    • View Object Properties
    • Collections of Objects in the Model View
    • Use Context Menus in the Model View
  • Bulk Editor
    • Using the Bulk Editor
    • Changing Item Display Order in the Bulk Editor
    • Display the Bulk Editor Pane in the Application
    • Auto Hide Feature
    • Bulk Editor Row-Level Copy
    • Bulk Editor Row-Level Paste
    • Bulk Editor Wizard
      • Specify Object Types to Use in the Bulk Editor
      • Specify Property Types to Use in the Bulk Editor
      • Specify Object Instances to Use in the Bulk Editor
      • Specify the Order of Rows and Columns to Display in the Bulk Editor
      • Manage Bulk Editor User Settings
      • Bulk Editor Wizard Option Sets
        • Save Your Selections in the Bulk Editor Wizard as an Option Set
  • The Action Log
    • The Action Log Pane
      • Display or Hide the Action Log Pane
      • Float the Action Log Pane in the Workspace
      • Dock the Action Log Pane
      • Resize the Action Log Pane
      • Save the Action Log Session
    • Action Log Metamodel Filter
      • Select Object and Property Types Displayed in the Action Log
    • Use the Details Pane
      • Expand a Transaction
      • Collapse a Transaction
    • Use the Summary Pane
    • View Property Change Details
    • Undo, Redo, and Reverse Functions
      • Undo a Transaction
      • Undo to Selected Transaction (Undo to This Point)
      • Redo a Transaction
      • Redo to Selected Transaction (Redo to This Point)
      • Reverse a Transaction
    • Use the Find and Find Next Options
    • How Extended Find and Filter Works
      • Use the Extended Find and Find Next Options
      • Use the Extended Find and Filter Options
      • Use the Filter Criteria Option
        • Display or Hide the Filter Selection
    • Creating an Action Log Report
  • The Advisories Pane
    • Advisories Pane
      • Display or Hide the Advisories Pane
      • Float the Advisories Pane in the Workspace
      • Dock the Advisories Pane
      • Resize the Advisories Pane
    • Advisory Details
    • Save Advisories Messages to a Text File
• Getting Started
  • Basic Features
  • File Types Supported
  • Create a New Model
  • Model Templates
  • Using Model Templates - Best Practices
  • Bind a Template to a Model
  • Model Template Synchronization Wizard
  • Refresh a Model Template
  • Filter the Display of Model Template Objects
  • Model Template Information Dialog
  • Unbind a Template from a Model
  • Save a Model as a Template
  • Synchronize Template Changes on Model Load
  • Open an Existing Model
  • Add Entities, Tables, and Views to Your Model
  • Find Entities, Tables, and Views
  • Print a Model
    • Specify General Page Setup Options
    • Save Your Page Setup Selections
    • Change Page Margins for Printing
    • Set Print Defaults at the Diagram Level
  • Paper Size Considerations When You Upgrade to This Release
  • Close a Model
  • Cut, Copy, and Paste Functions
    • Cut, Copy, and Paste Functions
    • Overview of Copying Objects
    • Copy Objects on the Diagram Window
    • Copy Attributes or Columns on the Diagram Window
    • Copy Objects to a Different Model
    • Copy Objects to a Different Diagram
    • How Copying Affects Foreign Keys and Relationships
    • Overview of Pasting Objects
    • Paste Objects on the Diagram Window
    • Overview of Deleting Objects
    • Delete Objects on the Diagram Window
    • Delete an Attribute or Column on the Diagram Window
    • Delete a Relationship
    • Select Objects on the Diagram Window
    • Multiple Attribute or Column Selection
    • Add an Object to a Set of Objects
  • Find and Replace
  • Editing Objects
    • Object Arrangement on the Diagram Window
    • Move Objects on the Diagram Window
    • Overview of Moving Attributes or Columns
    • Move an Attribute or Column on the Diagram Window
    • Overview of Resizing Entities, Tables, and Views
    • Resize Entities, Tables, and Views
  • Property Inheritance Features for Modeling Objects
  • Tracing the History of Model Objects
    • Model Object History
    • Configure History Tracking for Model Objects
    • View the History of Model Objects
    • View the History of the Model
    • The Text Editor
  • XML Format
    • Save a Model in XML Format (XML Export)
    • Open a Model Saved in XML Format (XML Import)
  • XML File Validation
    • Non-Printable Characters in XML Files
    • XML Schema
• Creating Models
  • Creating a Logical Model
    • Entities
      • Entity Editor
      • Add an Entity
      • Rename an Entity
      • Display an Entity Only in the Logical Model
      • Enter an Entity Definition
      • View History in a Property Editor
      • Enter an Entity User Note
      • Enter Entity User-Defined Property Values
      • Attach Icons to an Entity
      • Specify Volumetric Information for an Entity
    • Attributes
      • Entity Attribute Editor
      • Add an Attribute on the Diagram Window
      • Define General Properties for an Attribute
      • Specify the Validation Rule and Default Value for an Attribute
      • Specify the Logical Data Type for an Attribute
      • Rename an Attribute on the Diagram Window
      • Copy an Attribute on the Diagram Window
      • Move an Attribute on the Diagram Window
      • Summary of On-Diagram Editing
      • Add an Attribute to an Entity Using the Attribute Editor
      • Rename an Attribute Using the Attribute Editor
      • Delete an Attribute Using the Attribute Editor
      • Change the Order of Attributes Using the Attribute Editor
      • Assign a Domain to an Attribute
      • Add an Attribute Definition
      • View History in a Property Editor
      • Add an Attribute Note
      • Enter Attribute User-Defined Property Values
      • Assign Attribute Key Group Membership
      • Reset Attribute Properties
    • Key Groups
      • Entity Key Group Editor
      • Create an Alternate (Unique) Key Group
      • Change Attribute Key Group Membership in the Key Group Editor
      • Create an Inversion Entry (Non-Unique) Key Group
      • Display a Key Group Only in the Logical Model
      • Enter a Key Group Definition
      • Enter a Key Group Note
      • Enter Key Group User-Defined Property Values
      • Rename a Key Group
      • Delete a Key Group
    • User-Defined Properties
      • Create a User-Defined Property
      • User-Defined Property Data Types
      • Default Value Rules for a User-Defined Property
      • User-Defined Property Macros
      • Where to Use User-Defined Property Macros
      • User-Defined Property Macro Table
  • Creating a Physical Model
    • Tables
      • Table Addition Methods
      • Tables in the Model Explorer
      • Add a Table
      • Add Consecutive Multiple Tables
      • Rename a Table
      • Specify the Table Schema
      • Display a Table Only in the Physical Model
      • Accounting for Slowly Changing Dimensions
      • Tables and Validation Rules
      • Physical Storage Parameters for Tables
      • Table Editor
        • Define Dimensional Modeling Table Properties
        • Define Data Movement Rules for a Table
        • Enter Table Constraints and Validation Rules
        • Enter a Table Comment
        • Specify Volumetric Information for a Table
        • Enter Table User-Defined Property Values
        • Define DB2 for i Table Properties
        • Define Informix Table Physical Storage Properties
        • Define an Informix Table Partition
        • Define MySQL Table Properties
        • Define ODBC Table Properties
        • Define Progress Table Physical Storage Properties
        • Define SAS Table Properties
        • Define SQL Server 2000 Table Physical Storage Properties
        • Define Sybase Table Physical Storage Properties
        • Define Sybase IQ Table Properties
      • Table Synonym Names
        • Create a Synonym for a Table
        • Define an Informix Table Synonym
    • Columns
      • Assigning Column Properties
      • Table Column Editor
        • Define General Column Properties
        • Enter a Column Comment
        • Specify a Column Data Warehouse Source
        • Define Column Index Membership
        • Enter Column User-Defined Property Values
      • Add a Column to a Table Using the Table Column Editor
      • Define Basic Table Column Properties
      • Defining Table Column Properties for Target Databases
        • Define DB2 for i Table Column Properties
        • Define DB2 LUW Table Column Properties
        • Define DB2 z/OS Table Column Properties
        • Define Informix Table Column Properties
        • Define Progress Table Column Properties
        • Define SAS Table Column Properties
        • Define SQL Server 2000 Table Column Properties
        • Define Sybase IQ Table Column Properties
        • Define Teradata Table Column Properties
      • Add Columns Using a Domain
      • Rename a Column
      • Change the Order of Columns
      • Delete a Column
      • Assign a Domain to a Column
      • Assign Default and Validation Constraints to a Column
      • Remove a Column From an Index
      • Determining Column Properties
      • Reset Column Properties
    • Indexes
      • Index Default Values
      • Alternate Key Indexes
      • Primary Key Indexes
      • Inversion Entry Indexes
      • Create a Unique or Non-Unique Index
      • Change the Uniqueness Requirements for an Index
      • Delete an Index
      • Display an Index Only in the Physical Model
      • Prevent an Index From Generating in the Schema
      • Reorder Index Members
      • Table Index Editor
        • Define Index Members
        • Define DB2 for i Table Index Properties
        • Define Informix Table Index Properties
        • Define MySQL Table Index Properties
        • Define ODBC Table Index Properties
        • Define Progress Table Index Properties
        • Define SAS Table Index Properties
        • Define SQL Server 2000 Index Storage Properties
        • Define Sybase Table Index Properties
        • Define Sybase IQ Table Index Properties
        • Enter an Index Comment
        • Enter Index User-Defined Property Values
    • Views
      • Editors for Managing Views
      • Views in the Model Explorer
      • View Editor
        • Add a View
        • Define View Sources
        • Specify an Alias for a View Source Table
        • Define SQL Code Generation Criteria for a View
        • Change the SQL Code for a View
        • Enter a View Comment
        • Enter View User-Defined Property Values
        • Define View Columns
          • Change the Columns Referenced by a View
          • Reorder the Columns Referenced by a View
        • Delete a View Column Expression
      • View Column Editor
        • Define Basic View Column Properties
        • Defining View Column Properties for Target Databases
        • Assign a Domain to a View Column
        • Edit a View Column Expression
        • Enter a View Column Comment
        • Enter View Column User-Defined Property Values
        • Specify a View Column Data Warehouse Source
        • Delete a View Column
      • View Relationships Dialog
        • Add a View Relationship
        • Define View Relationship Properties
        • Assign an Alias to the Source Table or View Referenced Through a View Relationship
        • Enter a View Relationship Comment
        • Change the Sequence of the Tables Referenced by a View
    • Materialized Views
      • Materialized Views in the Model Explorer
      • Add a Materialized View Using the Model Explorer
      • Add a Materialized View to a Model
      • Change the Columns Referenced by a Materialized View
      • Delete a Materialized View Column Expression
      • Select the Source for a Materialized View
      • Specify an Alias for a Materialized View Source
      • Specify a Search Condition for a Materialized View
      • Change the SQL Code for a Materialized View
      • Enter Materialized View User-Defined Property Values
      • Add a Materialized View Expression
      • Add a Stored Procedure for a Materialized View
      • Attach a Materialized View to a Script
      • Add a Column Expression in the Materialized View Columns Editor
      • Assign a Domain to a Materialized View Column
      • Enter Materialized View Column User-Defined Property Values
    • Constraints
      • Target Server Constraint Terminology
      • Attaching a System Generated Default or Initial Value to a Column
      • Add a Default or Initial Value for a Target Server
      • Modify a Server Default Value
      • Delete a Default or Initial Value
      • Default Value Editor
    • Validation Rules
      • How CA ERwin Data Modeler Generates Validation Rules
      • Add a Validation Rule
      • Copy Valid Values from a Validation Rule
      • Specify Minimum or Maximum Values for a Validation Rule
      • Invert a Validation Expression
      • Specify a Progress Server Validation Error Message
      • Delete a Validation Rule
      • Create a Valid Value List
      • Sort the Valid Value List
      • Delete a Valid Value
      • Assign Validation Rule UDP Values
    • Triggers
      • Referential Integrity Triggers (RI Triggers)
      • Referential Integrity to Enforce Business Rules
      • DBMS Support for Triggers
        • Define a Table Trigger
        • Define an Informix Table Trigger
        • Define a Progress Table Trigger
        • Define a Sybase Table Trigger
        • Define an Informix View Trigger
        • Define a Sybase View Trigger
      • Default Trigger Templates
      • Create ERwin-Generated Triggers As Model Objects
      • Default Trigger Templates Example
      • Methods to Override Trigger Templates
        • RI Type Override Templates
          • Create an RI Type Override Trigger Template
          • Change an RI Type Override Trigger Template
          • Change the Template Attached to an RI Action
          • Delete an RI Type Override Trigger Template
        • Relationship Override Templates
          • Create a Relationship Override Trigger Template
          • Example: Relationship Override Template
        • Table Override Templates
      • Add a Table Override Trigger
      • Define a Table Override Trigger
      • Define the SQL Code for Table Override Triggers
      • Review Expanded Code for a Table Override Trigger
      • Enter a Comment for a Table Override Trigger
      • Define Table Override Trigger User-Defined Property Values
      • Generate Default Triggers for a Model
      • Trigger Defaults for Relationships
      • Change the Template that is Attached to an RI Trigger
      • Change the Default Referential Integrity Settings for All Relationships
      • Insert a Macro into a Template Code Window
      • Examples of Trigger Code
      • View Trigger Template Macro Code
    • Scripts
      • DBMS Support for Scripts
      • Add a New Script
        • Define a Pre & Post Script
        • View a Script for a Model, Table or View
        • Define Script SQL Code
        • Enter a Script Comment
        • Define Script User-Defined Property Values
      • Change the Order of Script Execution
      • Delete a Script for a Table or View
      • Rename a Script for a Table or View
      • Specify Script Sort Order
      • Script Template Browser
        • Attach a Table or View to a Script
        • View the Tables and Views Attached to a Script
        • Detach a Table or View from a Script
      • Generate a Script to the Schema
      • Schema Script Example
      • Script Use Examples
    • Stored Procedures
      • How Stored Procedures are Created
      • How to Access Stored Procedures
      • DBMS Support for Stored Procedures
      • Reverse Engineering with Stored Procedures
      • Forward Engineering with Stored Procedures
      • DBMS Migration
      • Migrate a Stored Procedure
      • Add a Stored Procedure for a Table or View
        • Define a Stored Procedure
        • Define the Stored Procedures SQL Code
        • Review the Expanded SQL Code for a Stored Procedure
        • Enter a Comment for a Stored Procedure
        • Enter Stored Procedure User-Defined Property Values
      • Rename a Stored Procedure
      • Change the Order in Which Stored Procedures Generate
      • Procedure Browser
        • View the Tables and Views Attached to a Stored Procedure
        • Attach a Table or View to a Stored Procedure
        • Detach a Table or View from a Stored Procedure
      • Teradata Stored Procedures (Macros)
    • Physical Storage Objects
      • Add a Physical Storage Object
        • Add a New Object
        • Shortcut for Adding Objects
        • Rename an Object
      • Change Physical Storage Object Parameters
      • Enter a Comment for a Physical Storage Object
      • Enter Physical Object User-Defined Property Values
      • Nesting Physical Storage Objects
      • Define Informix DBSpaces
      • Define Sybase Segments
  • Creating a Dimensional Model
    • Dimensional Modeling
      • Overview of Documenting a Dimensional Model
      • Star Schema Design
      • Characteristics of a Star Schema
      • Fact Table
      • Dimensional Modeling Roles Assignments
      • Manually Assign Dimensional Modeling Roles
      • Conformance Warnings
      • Dimension Table
      • Overview of Large Dimension Tables Partitioning
      • Outrigger Table
      • Snowflake Schema
      • Convert an Entity Relationship Model to a Dimensional Model
      • Data Movement Rules
        • Create a Data Movement Rule
        • Delete a Data Movement Rule
        • Attach a Data Movement Rule
        • Detach a Data Movement Rule
  • Target Servers for Physical Models
    • Changing the Target Server
      • Target Servers and the Physical Model
      • Select or Change the Target DBMS
      • Define the Default Datatype for New Columns
      • Define the Default Null Option for New Columns
      • Changing the Target DBMS
      • Convert Datatypes When Changing the Target DBMS
      • DBMS Connection Software
      • Database Connection Overview
      • Connect to the Database or Mart
      • Database Connection Parameters
      • Connecting to SQL Azure
      • Disconnect From the Target DBMS
      • Generic Open Database Connectivity (ODBC)
      • Select Generic ODBC
      • ODBC Data Sources
      • Define an ODBC Data Source
      • Warning: Database Not Supported
    • Database Property Editors
      • Oracle Physical Property Editors
        • Oracle Cluster Editor
          • Oracle Cluster Editor - General Tab
          • Oracle Cluster Editor - Storage Tab
          • Oracle Cluster Editor - Options Tab
          • Oracle Cluster Editor - Index Tab
          • Select Cluster Dialog Options
        • Define Oracle View Column Properties
        • Oracle Database Editor
          • Define General Options for an Oracle Database
          • Oracle Database Editor - Logging Tab
          • Oracle Database Editor - Tablespace Tab
        • Oracle Database Link Editor
          • Oracle Database Link Editor - General Tab
        • Oracle Directory Editor
          • Oracle Directory Editor - General Tab
        • Oracle Disk Group Editor
          • Oracle Disk Group Editor - General Tab
          • Oracle Disk Properties Dialog
        • Oracle Index Editor for Materialized Views
        • Oracle Table Index Editor
          • Oracle Table Index Editor - Constraint State Tab
        • Oracle Library Editor
          • Oracle Library Editor - General Tab
        • Oracle Materialized View Column Editor
          • Oracle Materialized View Column Editor - General Tab
          • Oracle Materialized View Column Editor - Expression Tab
        • Oracle Materialized View Log Editor
          • Oracle Materialized View Log Editor - General Tab
          • Oracle Materialized View Log Editor - Other Options Tab
          • Oracle Materialized View Log Editor - Physical Props Tab
        • Oracle Materialized View Editor
          • Oracle Materialized View Editor - LOB Storage Tab
          • Oracle Materialized View Editor - Other Options Tab
          • Oracle Materialized View Editor - Refresh Tab
        • Oracle Package Editor
          • Oracle Package Editor - Body Tab
          • Oracle Package Editor - Context Tab
          • Oracle Package Editor - Specification Tab
        • Oracle Package Body Editor
        • Define Oracle Script Templates
          • Pre and Post Scripts Editor - Code Tab
          • Pre and Post Scripts Editor - Expanded Tab
          • Pre and Post Scripts Editor - General Tab
        • Oracle Rollback Segment Editor
          • Oracle Rollback Segment Editor - General Tab
        • Oracle Sequence Editor
          • Oracle Sequence Editor - General Tab
        • Oracle Storage Properties Dialog
        • Oracle Stored Procedure and Function Editor
          • Browser Dialog for Functions, Script Templates, and Stored Procedures
        • Oracle Subpartition Storage Dialog
        • Oracle Synonym Editor
          • Oracle Synonym Editor - General Tab
          • erw_hlp--Oracle Synonym Editor - Alias Tab
        • Oracle Table Editor
          • Oracle Table and Materialized View Editor - General Tab
          • Oracle Table Editor - LOB Storage Tab
          • Oracle Table Editor - Materialized View Log Tab
          • Oracle Table Editor - Supplemental Logging Tab
          • Oracle Table Editor - Table Options Tab
          • Oracle Table Editor - Validation Tab
          • Oracle Index Organized Table
          • Oracle Overflow Segment Attributes Editor
          • Oracle External Table Dialog
          • Oracle List Subpartition Dialog
          • Oracle Partition Description Dialog
            • Oracle LOB Parameters Dialog
            • Oracle LOB Storage Dialog
            • Oracle Select Columns Dialog
          • Oracle Partition Storage Dialog
          • Oracle Partition Values Dialog
          • Oracle Select Tablespaces Dialog
          • Oracle Hash Subpartition Dialog
        • Oracle Table Column Editor
          • Define Default and Validation Constraints for an Oracle Column
          • Oracle Constraint State Dialog
          • Define Oracle Default Values
          • Define an Oracle Default Value
          • Define General Properties for an Oracle Table Column
          • Define Oracle Table Column Properties
          • Define Index Membership for an Oracle Column
          • Oracle Attach Columns for Logging Dialog
        • Oracle Tablespace Editor
          • Oracle Tablespace Editor - Files Tab
          • Oracle Tablespace Editor - General Tab
          • Oracle Tablespace Editor - Storage Tab
        • Oracle Tablespace Group Editor Dialog
          • Oracle Tablespace Group Editor - General Tab
        • Oracle Triggers Editor
          • Define an Oracle Database Trigger
          • Oracle Triggers Editor - Materialized Views Triggers - Table Options Tab
          • Oracle Triggers Editor - Table Triggers - General Tab
          • Oracle Triggers Editor - Views Triggers - Table Options Tab
          • Oracle Triggers Editor - Database Triggers
          • Oracle Triggers Editor - Materialized Views Triggers
          • Oracle Triggers Editor - Table Triggers
          • Oracle Triggers Editor - Views Triggers
        • Oracle Views Editor
          • Oracle Views Editor - Constraints Tab
        • View SQL Code for a Physical Object
        • Edit the User Defined SQL Code
        • Add an Expression to an Oracle Table or Materialized View Index
        • Define Table Partition in Oracle 11g
        • Define a Subpartition in Oracle 11g
        • Define a Partition Element in Oracle 11g
          • Define Partition Boundaries in Oracle 11g
          • Define Valid Values for Partition Elements in Oracle 11g
          • Define a Subpartition Element in Oracle 11g
          • Define Regular Storage Properties for Oracle Partition Elements
          • Define Overflow Storage Properties for Oracle Partition Elements
      • SQL Server Property Editors
      • SQL Server Support Summary
      • SQL Server 2000 Property Editors
        • Define a SQL Server 2000 Filegroup
      • SQL Server 2005 Property Editors
        • Define SQL Server 2005 Aggregates
        • Define a SQL Server 2005 Asymmetric Key
        • Define a Credential in SQL Server 2005
        • Define a Database in SQL Server 2005
          • Define SQL Server 2005 Database Files
            • Define a Database Filegroup in SQL Server 2005
            • Define a Database Log File in SQL Server 2005
          • Define Options for a SQL Server 2005 Database
          • SQL Server 2005 Physical Files
            • Add a Physical File to a Filegroup in SQL Server 2005
            • Define Physical Files for a Database in SQL Server 2005
          • Define SQL Server 2005 Files
        • Define SQL Server 2005 Functions
        • Define a Table in SQL Server 2005
        • Define SQL Server 2005 Table Column Properties
        • Define a Table Full-Text Index in SQL Server 2005
        • Define a Table Index in SQL Server 2005
          • Define Options for a SQL Server 2005 Table Index
        • Define a Symmetric Key in SQL Server 2005
        • Define SQL Server 2005 Views
          • Define SQL Server 2005 View Columns
          • Define a SQL Server 2005 View Column Expression
          • Select the Tables and Views for a SQL Server 2005 View
          • Specify Properties for the WHERE Clause for a SQL Server 2005 View
        • Define a View Index in SQL Server 2005
          • Define Options for a SQL Server 2005 View Index
      • New r8 SQL Server 2008 Support in CA ERwin Data Modeler
        • Version Compatibility
        • Filtered Indexes
          • Sparse Columns
        • Spatial Indexes
        • Change Data Capture
          • Synchronous Net-Changes Change Tracking
        • Support for New Data Types
        • Data Compression
        • SQL Server Audit
        • Resource Governor
        • Transparent Data Encryption
        • Extensible Key Management
        • Full-text Stoplists
      • SQL Server 2008 Property Editors
        • Define SQL Server 2008 Aggregates
        • Define an Asymmetric Key in SQL Server
        • SQL Server 2008 Audit Specifications
          • Define a SQL Server 2008 Server Audit
          • Define a SQL Server 2008 or 2012 Server Audit Specification
        • Define a Credential in SQL Server
        • Define a SQL Server Cryptographic Provider
        • Define a Database in SQL Server 2008
          • Enable Change Data Capture for a SQL Server 2008 Database
          • SQL Server 2008 Database Audit Specifications
            • Define a SQL Server 2008 Database Audit Action
            • Define a SQL Server 2008 Database Audit Specification
          • Define a Database Filegroup in SQL Server 2008
          • Define SQL Server 2008 Database Files
          • Define Options for a SQL Server 2008 Database
          • SQL Server 2008 Physical Files
            • Add a Physical File to a Filegroup in SQL Server 2008
            • Define Physical Files for a Database in SQL Server 2008
          • Define SQL Server 2008 Files
        • Define a SQL Server 2008 Database Encryption Key
        • Define a SQL Server 2008 Full-Text Stoplist
        • Define SQL Server 2008 and 2012 Functions
          • Specify the Return Order for a Table Return Assembly Function
        • Define a SQL Server 2008 Resource Pool
        • Define a Symmetric Key in SQL Server 2008 or 2012
        • Define a Table in SQL Server 2008
          • Define Change Data Capture Settings for a SQL Server 2008 Table
          • Define Change Data Capture Properties
        • Define SQL Server 2008 Table Column Properties
        • Define a Table Index in SQL Server 2008
          • Define Options for a SQL Server 2008 Table Index
        • Define a Table Full-Text Index in SQL Server 2008 and 2012
        • Define a SQL Server 2008 or 2012 Table Spatial Index
        • Define a View in SQL Server 2008
          • Define SQL Server 2008 View Columns
          • Define a SQL Server 2008 View Column Expression
          • Select the Tables and Views for a SQL Server 2008 View
          • Specify Properties for the WHERE Clause for a SQL Server 2008 View
        • Define a View Index in SQL Server 2008
          • Define Options for a SQL Server 2008 View Index
        • Define a SQL Server 2008 Workload Group
      • SQL Server Common Functionality
        • Define SQL Server Assemblies
        • SQL Server Browser for Functions, Script Templates, and Stored Procedures
        • Define SQL Server Certificates
        • Define SQL Server Full-Text Catalogs
        • SQL Server Partitions
          • Define a Partition for a SQL Server Table
          • Define a Partition for a SQL Server Table Index
          • Define a Partition for a SQL Server View Index
          • Define SQL Server Partition Functions
          • Define SQL Server Partition Schemes
        • Define SQL Server Permissions
        • SQL Server Principals
          • Define SQL Server Application Roles
          • Define SQL Server Database Roles
          • Define SQL Server Logins
          • Define SQL Server Users
        • Define SQL Server Schemas
        • Define SQL Server Stored Procedures
        • Define SQL Server Synonyms
        • Define SQL Server Table XML Indexes
        • SQL Server Triggers
          • DML Triggers
          • DDL Triggers
          • Define SQL Server Database Triggers
          • Define SQL Server 2005 Triggers
          • Define SQL Server 2008 Triggers
          • Define SQL Server Table Triggers
          • Define SQL Server View Triggers
        • Define SQL Server View Column Properties
        • Define SQL Server XML Schema Collections
        • Define the Code Type for an Object in a SQL Server Property Editor
        • Define Data Compression for Tables, Table Indexes, or View Indexes in SQL Server 2008
        • Define Permissions for an Object in a SQL Server Property Editor
        • Define Validation Rule Usage for a SQL Server Table
        • Define Volumetrics for a SQL Server Table
        • Add a UDP in a SQL Server Physical Property Editor
      • SQL Server 2012 Property Editors
        • Define SQL Server 2012 Aggregates
        • Column Store Index
          • Define a Table ColumnStore Index in SQL Server 2012
        • Define a SQL Server 2012 Certificate
        • Define a Database in SQL Server 2012
        • Define a SQL Server 2012 Database Audit Specification
        • Define SQL Server 2012 Files
        • Define SQL Server 2012 Database Files
          • Define a Database Filegroup in SQL Server 2012
          • Add a Physical File to a Filegroup in SQL Server 2012
          • Define Physical Files for a Database in SQL Server 2012
        • Define Options for a SQL Server 2012 Database
        • Define a SQL Server 2012 Resource Pool
        • Define a SQL Server 2012 Full-Text Stoplist
        • Sequence
          • Creating a Sequence in SQL Server 2012
        • Define a SQL Server 2012 Server Audit
        • Define a SQL Server 2012 Workload Group
      • SQL Azure Property Editors
        • SQL Azure Database Support in CA ERwin Data Modeler
          • Database Properties
            • Define a Database in SQL Azure
          • Define SQL Azure Database Roles
          • Default Value Properties
            • Add a Default or Initial Value for a SQL Azure Target Server
          • Domain Properties
            • Define SQL Azure Domain Properties
          • Function Properties
            • Define SQL Azure Functions
          • Index Properties
            • Define a Table Index in SQL Azure
              • Define Options for a SQL Azure Table Index
          • Login Properties
            • Define SQL Azure Logins
          • Define SQL Azure Permissions
          • Table and Column Properties
            • Define a Table in SQL Azure
              • Define SQL Azure Table Column Properties
              • Define Validation Rule Usage for a SQL Azure Table
              • Define Volumetrics for a SQL Azure Table
          • Schema Properties
            • Define SQL Azure Schemas
            • Define SQL Azure Schema Generation Schema Options
          • Spatial Index Properties
            • Define a SQL Azure Table Spatial Index
          • Stored Procedure Properties
            • Define SQL Azure Stored Procedures
            • SQL Azure Browser for Functions, Script Templates, and Stored Procedures
          • Synonym Properties
            • Define SQL Azure Synonyms
          • Trigger Properties
            • DML Triggers
            • DDL Triggers
            • SQL Azure Triggers
              • Define SQL Azure Database Triggers
              • Define SQL Azure Table Triggers
              • Define SQL Azure View Triggers
          • User Id Properties
            • Define SQL Azure Users
          • Validation Rule Properties
            • Add a SQL Azure Validation Rule
          • View Properties
            • Define a View in SQL Azure
              • Define SQL Azure View Columns
              • Define a SQL Azure View Column Expression
              • Select the Tables and Views for a SQL Azure View
              • Specify Properties for the WHERE Clause for a SQL Azure View
          • SQL Azure Common Functionality
            • Define Permissions for an Object in a SQL Azure Property Editor
            • Define the SQL Code for an Object in a SQL Azure Property Editor
      • Teradata Physical Property Editors
        • Teradata Support Summary
        • Authorize Teradata Database Users
        • Specify Teradata Conversion Routines (Casts)
        • Define Teradata Database Roles
        • Define Teradata Databases
        • Define Teradata Default Values
        • Define Teradata Display Format Options
        • Specify Teradata Domains in a Physical Model
        • Define the Physical Location of a Teradata File
        • Add User-Defined Teradata Functions
          • Specify Data Access Options
        • Create Teradata Global Persistent Data Sets
        • Define Teradata Hash Indexes
        • Define Teradata Join Indexes
        • Define Teradata Indexes
          • Specify Options for a Teradata Index
          • Specify the Order of the Columns for a Teradata Index
        • Define Teradata Macros
        • Define Teradata Methods
          • Specify Data Access Options for a Teradata Method
          • Specify the Return Values for a Teradata Method
          • Specify Parameters for a Teradata Method
        • Define Teradata Permissions
        • Define Teradata Profiles
          • Specify and Order the Account IDs in a Teradata Profile
          • Specify Password Options of a Teradata Profile
        • Define Teradata Replication Groups
        • Create Teradata Replication Rule Sets
          • Create a Teradata Replication Rule
        • Define Teradata Stored Procedures
          • Specify Data Access Options for a Stored Procedure
        • Define Teradata Tables
          • Define Data Movement Rules
          • Specify Error Table Options
          • Define Constraints that are Associated with the Table
        • Define Teradata Table Triggers
        • Define Teradata Users
          • Specify and Order the Account Identifiers for a User Id
        • Define Teradata Views
          • Define the Locking Options for a Teradata View
          • Define a Teradata View Column Expression
        • Teradata Browser Editor for Functions, Script Templates, and Stored Procedures
          • Attach or Detach a Teradata Table or View to a Macro
          • Attach or Detach a Teradata Table or View to a Stored Procedure
      • Teradata Common Property Pages
        • Edit Code in a Teradata Property Editor
        • Add Permissions in a Teradata Property Editor
        • Specify Source Files for a Physical Object
        • Specify External Files for a Physical Object
        • Specify Journal Options for a Physical Object
        • Specify Parameters for the Selected Physical Object
        • Specify Statistics Options for a Teradata Table, Hash Index, or Join Index
      • DB2 z/OS Property Editors
        • Define a DB2 z/OS Database Role
        • Define a DB2 z/OS Database
        • Define a DB2 z/OS File
        • Define DB2 z/OS Permissions at Database Level
        • Define DB2 z/OS Permissions at Object Level
        • Define a DB2 z/OS Schema
        • Define a DB2 z/OS Sequence
        • Define a DB2 z/OS Auxiliary Table
        • Define a DB2 z/OS Auxiliary Table Index
        • Define a DB2 z/OS Storage Group
        • Define a DB2 z/OS Tablespace
        • Define DB2 z/OS Tablespace Partition Elements
        • Define a DB2 z/OS Trusted Context
        • Define DB2 z/OS Users
        • Define a DB2 z/OS Table
          • Define DB2 z/OS Table Synonyms
          • Define a DB2 z/OS Table Trigger
        • Define DB2 z/OS Table Column Properties
        • Define DB2 z/OS Table Partition Elements
        • Specify DB2 z/OS Using Clause Parameters
        • Define a DB2 z/OS Function
        • Define a DB2 z/OS Index
        • Define DB2 z/OS Table or Index Partitions
        • Define a DB2 z/OS XML Index
        • Specify DB2 z/OS Using Clause Parameters for XML Index
        • Define a DB2 for z/OS XML Pattern for XML Index
        • Define DB2 for z/OS View Column Properties
        • Define a DB2 z/OS View Trigger
        • Define DB2 z/OS Stored Procedures
      • DB2 LUW Property Editors
        • Define a DB2 LUW Bufferpool
        • Define DB2 LUW Database Partition Groups
          • Define a DB2 LUW Database Partition
        • Support for Federation in DB2 LUW
          • Define DB2 LUW Function Mappings
          • Define DB2 LUW Type Mappings
          • Create a DB2 LUW Server
          • Define DB2 LUW Wrappers
          • Define DB2 LUW User Mappings
          • Define a DB2 LUW Nickname
        • Define a DB2 LUW Global Variable
        • Define a DB2 LUW Index
        • Define a DB2 LUW Index Extension
        • Define a DB2 LUW Module
          • Define a DB2 LUW Module Object Definition
        • Support for Security Features in DB2 LUW
          • Define a DB2 LUW Audit Policy
          • Define DB2 LUW Security Label Components
          • Create a DB2 LUW Security Label
          • Create a DB2 LUW Security Label Element
          • Define a DB2 LUW Security Policy
          • Define a DB2 LUW Trusted Context
        • Define a DB2 LUW Alias
        • Define a DB2 LUW Table
        • Define DB2 LUW Table Column Properties
        • Define DB2 LUW Global Temporary Table
        • Define a DB2 LUW Tablespace
        • Define DB2 LUW XML Indexes
        • Define a DB2 LUW Table Trigger
        • Define a DB2 LUW Dimension Group
        • Define a DB2 LUW View Trigger
        • Define DB2 LUW Event Monitor Properties
        • Define DB2 LUW Event Monitor Group Properties
        • Support for Workload Features in DB2 LUW
          • Define DB2 LUW Thresholds
          • Set Properties for a DB2 LUW Histogram Template
          • Define DB2 LUW Service Classes
          • Define DB2 LUW Work Action Sets
          • Define a DB2 LUW Work Action
          • Define a DB2 LUW Work Class
          • Define DB2 LUW Work Class Sets
          • Define DB2 LUW Workloads
        • Define a DB2 LUW Database Role
        • Define a DB2 LUW File
        • Define a DB2 LUW Function
        • Define DB2 LUW Table or Index Partitions
        • Define DB2 LUW Table Partition Elements
        • Define DB2 LUW Permissions at Database Level
        • Define DB2 LUW Permissions at Object Level
        • Define a DB2 LUW Schema
        • Define a DB2 LUW Sequence
        • Define DB2 LUW Stored Procedures
        • Define DB2 LUW Users
        • Specify DB2 LUW Using Clause Parameters
      • Materialized Query Tables
        • Add a Materialized Query Table
        • The Materialized Query Table Editor
        • Define the Properties of a Materialized Query Table
          • Specify the Source Tables for a Materialized Query Table
          • Specify the Materialized Query Columns
          • Specify Search Conditions for Generating the SQL Code for a Materialized Query Table
          • Specify General Physical Properties for a Materialized Query Table
          • Create Query Options for a Materialized Query Table
          • Create Distribution Options for a Materialized Query Table
          • Specify an Organization Type for a Materialized Query Table
          • Create User-Defined SQL Code for a Materialized Query Table
        • Add a Stored Procedure for a Materialized Query Table
        • Attach a Materialized Query Table to a Script
        • Define Materialized Query Table Triggers
        • Materialized Query Column
          • Add a Materialized Query Column Expression
          • Add a Materialized Query Column Expression in the Materialized Query Tables Editor
          • Edit the Materialized Query Columns Select Expression
          • Assign a Domain to a Materialized Query Column
      • Common Property Pages
        • Create an Annotation
        • Define Script Templates (Pre and Post Scripts)
        • Filter Objects in a Property Editor
        • Browser Dialog for Functions, Script Templates, and Stored Procedures
        • View SQL Code for a Physical Object
        • Select the Tables and Columns for the View or Join Index
        • Define User-Defined SQL Code
        • View Expanded Code in a Property Editor
        • Work With Roles in a Property Editor
        • Change the Object Creation Order for Tables or Views
        • View History in a Property Editor
        • The Notes Tab
        • Change the Object Creation Order in a Property Editor
        • Add a Comment in a Property Editor
        • Specify the Icon to Display for a Table or View
        • Define the Style for a Table, View, or Column
        • View the Where Used Information for a Physical Object
        • Spell Check a Comment in a Property Editor
          • Set Spelling Options
          • Customize a Spelling Dictionary
          • Create a New Spell Check Dictionary
          • Import or Export Spelling Dictionary Words
          • Add a Dictionary File to the Spelling Dictionary
        • Add a UDP in a Physical Property Editor
        • Enter or Edit a Link Object Definition
        • Define a Dimensional Modeling Role in a Property Editor
        • Define Data Movement Rules in a Property Editor
  • Model Properties
    • The Model Properties Dialog
    • Set General Model Properties
    • Set Default Null Options, Data Types, Styles, and Object Owners
    • Set Default Referential Integrity Rules
    • Specify History Options for Model Objects and Events
    • Add Comments to Your Model
    • Assign Model UDP Values
  • The Theme Editor
    • Overview of Themes
    • Formatting Toolbar
    • Fonts and Colors Formatting Options
      • Formatting Options in the Theme Editor
      • Create a New Theme
      • Set Font and Fill Preferences for Objects
      • Set Display Preferences for Entities
      • Set Display Preferences for Tables
        • Define the General Font Options
        • Define the General Fill Options
        • Define the General Line Options
        • Define the General Outline Options
        • Define the Diagram Fill Options
      • Set Display Preferences for Owned Attributes and Foreign Keys
      • Set Display Preferences for Owned Columns and Foreign Keys
      • Set Display Preferences for Keys
      • Set Display Preferences for Views
      • Set Display Preferences for Materialized Views
      • Set Display Preferences for Relationships
      • Set Display Preferences for Subtype Symbol
      • Set Display Preferences for Annotations and Shapes
      • Using a Model to Import Styles
  • The Image Editor
    • Specify Image Properties
    • Program Icons Supplied
  • Drawing Objects
    • Drawing Objects
    • Drawing Object Perimeter Line
    • Object Grouping on the Diagram Window
    • Drawing Object Layering
    • Entity or Table Layering
    • Docked Toolbar Indicator
    • Draw a Square or Rectangle
    • Draw a Rounded Rectangle
    • Draw a Circle or Ellipse
    • Draw a Line
    • Draw a Polyline
    • Add Text to a Drawing Object
    • Copy a Drawing Object
    • Object Alignment
    • Align Drawing Objects
    • Change Font and Color for a Drawing Object
    • Select a Drawing Object
    • Delete a Drawing Object
    • Display a Drawing Object
    • Group Objects on the Diagram Window
    • Ungroup Objects on the Diagram Window
    • Layer Drawing Objects
    • Resize a Drawing Object
    • Rename an Object on the Diagram Window
    • On-Diagram Editing Functions
    • Use the Go To Editor
  • Annotation
    • Add an Annotation
    • Delete an Annotation
    • Add or Edit Text in an Annotation
    • Change the Font and Color of Text
  • Diagrams
    • Diagrams
    • Create a New Diagram
    • Delete a Diagram
    • The Diagram Editor
    • Set Diagram Options Using the Diagram Editor
    • Specify an Author for a Diagram
    • Select Members for a Diagram
    • Include Objects from Another Diagram
    • Sort Options
    • Display Name Format Options
    • Override Font and Color for a Shape
    • Manage Relationships for a Diagram
    • Relationship Lines
    • Set Layout Preferences for a Diagram
    • Set Display Preferences for a Diagram
    • Set Entity Display Preferences
    • Set Table Display Preferences
    • Set Display Options for Views
    • Set Display Options for Relationships
    • Set Page Setup Defaults for Printing
    • Set Header, Footer and Margin Defaults for Printing
    • Rename a Diagram
    • Add Drawing Objects to a Data Model
    • Lay Out a Diagram Automatically
      • Preserve Layout When Laying Out a Diagram
  • Subject Areas
    • Subject Areas
    • Create a Subject Area
    • Delete a Subject Area
    • Specify an Author of a Subject Area
    • Enter Subject Area User-Defined Property Values
    • Select Members of a Subject Area
    • Include or Exclude Ancestors or Descendants of the Selected Entity, Table, or View in the Subject Area
    • Enter a Comment for a Subject Area
    • Switch Between Subject Areas
• Relationships and Domains
  • Relationships in the Logical Model
    • Relationships in the Logical Model
    • Identifying Relationships in a Logical Model
    • Add an Identifying Relationship
    • Add Multiple Consecutive Identifying Relationships
    • Non-Identifying Relationships in the Logical Model
    • Optional Non-Identifying Relationships in the Logical Model
    • Mandatory Non-Identifying Relationships in the Logical Model
    • Add a Non-Identifying Relationship
    • Add Multiple Consecutive Non-Identifying Relationships
    • Subtype Relationships in the Logical Model
    • Add a Complete Subtype Relationship
    • Add an Incomplete Subtype Relationship
    • Add an Inclusive Subtype Relationship
    • Add an Exclusive Subtype Relationship
    • Assign a Discriminator to a Subtype Relationship
    • Many-to-Many Relationships in the Logical Model
    • Add a Many-to-Many Relationship
    • Add Multiple Consecutive Many-to-Many Relationships
    • Resolve a Many-to-Many Relationship in a Logical Model
    • Recursive Relationships
    • Add a Hierarchical Recursive Relationship
    • Add a Network Recursive Relationship
    • Relationship Tools in the Logical Model
    • Add a New Relationship in a Logical Model
    • Change the Relationship Type
    • Display a Relationship in the Logical Model Only
    • Highlighting Relationship Lines
    • Parent Child Edit Selector
    • Navigate a Model Using Relationships
    • Delete a Relationship
    • Verb Phrases for Relationships
    • Add a Two-Part Verb Phrase
    • View Verb Phrases in a Logical Model
    • Relationship Cardinality
    • Set Relationship Cardinality
    • View Cardinality Symbols in a Logical Model
    • Relationship Null Options
    • Set the Default Null Option for a Non-Identifying Relationship
    • Change the Null Option for a Non-Identifying Relationship
    • Attribute Rolenames
    • Assign a Rolename to an Attribute
    • Delete a Rolename
    • Enter a Definition for a Relationship
    • Referential Integrity Trigger Actions
    • Relationship Editor - RI (Referential Integrity) Actions Tab Options
    • Assign Relationship UDP Values in the Logical Model
    • Foreign Key Migration
    • Unifying Relationships
    • Control Migrating Foreign Key Unification
    • Alternate Key Migration
    • Migrate an Alternate Key as a Foreign Key
  • Relationships in the Physical Model
    • Relationships in the Physical Model
    • Identifying Relationships in a Physical Model
    • Non-Identifying Relationships in the Physical Model
    • Optional Non-Identifying Relationships in the Physical Model
    • Mandatory Non-Identifying Relationships in the Physical Model
    • Relationship Tools in the Physical Model
    • Add a New Relationship in a Physical Model
    • Recursive Relationships
    • Specify Physical Properties for a Relationship
    • Set the Default Null Option for a Non-Identifying Relationship
    • Display a Relationship in the Physical Model Only
    • Delete a Relationship
    • Set Relationship Cardinality
    • Foreign Key Names
    • Assign a Foreign Key Constraint Name
    • Enter a Foreign Key Comment to a Relationship
    • Assign a Rolename to a Migrated Index
    • Define Referential Integrity Trigger Actions for Relationships
    • Assign Relationship UDP Values in a Physical Model
    • Subtype Relationships in the Physical Model
    • Partial Key Migration
    • Migrate a Partial Key in the Physical Model
  • Domains and Data Modeling
    • Speed Modeling with Domains
    • Save User Defined Domains to a New Model
    • Domains in the Logical Model
      • The Domain Editor in Logical Edit Mode
      • Add a Domain in the Logical Edit Mode
      • Change a Logical Domain Name
      • Delete a Logical Domain
      • Specify a Data Type for a Domain
      • Specify a Domain Parent in the Logical Model
      • Specify That a Domain Appears in the Logical Model Only
      • Specify a Validation Rule and Default Value for a Domain in the Logical Model
      • Specify a Domain Definition in the Logical Model
      • Specify Attribute Domain User-Defined Property Values
    • Domains in the Physical Model
      • The Domain Editor in Physical Edit Mode
      • Add a Domain in the Physical Edit Mode
      • Change a Physical Domain Name
      • Delete a Physical Domain
      • Specify a Domain Parent in the Physical Model
      • Specify That a Domain Appears in the Physical Model Only
      • Define Basic Domain Physical Properties
      • Specifying Database-Specific Options For a Domain
        • Define DB2 for i Domain Properties
        • Define DB2 LUW Domain Properties
        • Define DB2 z/OS Domain Properties
        • Define Informix Domain Properties
        • Define Oracle Domain Properties
        • Define Progress Domain Properties
        • Define SAS Domain Properties
        • Define SQL Server 2005 Domain Properties
        • Define SQL Server 2008 Domain Properties
        • Define Sybase IQ Domain Properties
      • Specify a Data Source For a Domain
      • Specify a Validation Rule and Default Value for a Domain in the Physical Model
      • Specify a Validation Rule and Default Value for an Oracle Domain
      • Specify a Validation Rule and Default Value for a Teradata Domain
      • Specify a Column Definition Using a Physical Domain
      • Specify a Domain Comment in the Physical Model
      • Specify Column Domain User-Defined Property Values
      • User Data Type Support Using Domains
        • Summary of User Data Type Schema Generation Options
          • DB2 LUW Distinct Types
          • SQL Server and Sybase User Data Types
        • Add a User-Defined Data Type in a Physical Model
    • Domain Inheritance and Overrides
    • Domain Properties
    • Resetting Domain Inheritance
    • Reset Domain Properties to Their Default Values
• Working with Data Models
  • Forward Engineer/Alter Script
    • Model Validation Check
    • Check Your Model/Validate SQL
      • Validation Criteria for Oracle Models
      • Validation Criteria for SQL Server 2005 Models
      • Validation Criteria for Teradata Models
    • Forward Engineering/Schema Generation
      • Select Schema Generation Options (Forward Engineering)
      • Save an Option Set
      • Review Schema Generation Options (Forward Engineering)
      • Preview the Script (Forward Engineering)
      • Change Schema Generation Options (Forward Engineering)
      • Generate the Schema from the Schema Generation Preview Dialog (Forward Engineering)
      • Generate the Schema to the Target Server (Forward Engineering)
      • Save a Schema DDL Script File (Forward Engineering)
    • Alter Script/Schema Generation
    • Select Schema Generation Options
      • Define Schema Generation Schema Options
      • Define Schema Generation Materialized Query Table Options
      • Define Schema Generation Table Options
      • Define Schema Generation Column Options
      • Define Schema Generation View Options
      • Define Schema Generation Index Options
      • Define Schema Generation Referential Integrity Options
      • Define Schema Generation Trigger Options
      • Define Schema Generation Other Options
    • Display Schema Generation Options
    • Override Schema Generation Owner
    • Enter a Comment for the Current Schema Generation Option Set
    • Preview the Schema DDL Script
    • Generate Database Schema Options
    • Example - Physical or Column Order in Forward Engineering
    • Forward and Reverse-Engineering Physical Storage Objects
    • Forward and Reverse-Engineering Indexes
    • Forward and Reverse Engineering Validation Rules
    • Column and Table Level Validation Table
    • Filter Tables in the Schema Generation Dialog for Forward Engineering
    • Dangling Relationships
    • Dangling Relationships in Schema Generation
    • Filter Dangling Relationships from the Schema
    • Summary of Alter Statement Restrictions
    • Forward Engineering Template Files
      • Using a Custom Template File During Schema Generation
      • Using Option Sets
      • Restore a Forward Engineering Template File
    • The Template Editor
      • Template Editor Toolbar
      • Sample Context
      • Templates Pane
      • Macros Pane
        • Add a Macro to a Template
        • Show Detailed Information for a Macro
        • Edit Macro Categories
          • Create a Custom Macro Category
          • Rename a Custom Macro Category
          • Delete a Custom Macro Category
      • Template Source Pane
      • Expanded Text Pane
      • Open a Template
      • Open a Template File
      • Create a New Template
      • Create a New Template File
      • Customize a Template File
      • Customize a Template File During Schema Generation
      • Open a Different Template File to Use with Forward Engineering
      • Open a Different Template File to Use with Alter Script/Schema Generation
      • Print Current Template Source
      • Save a Template File
      • Delete a Template
      • Template Editor Preferences
        • Set Color Preferences for Template Source
        • Set Color Preferences for Expanded Text
        • Set Macro Display Preferences
      • Template Editor Search and Display Options
  • How to Reverse Engineer a Model from a Database or a Script
    • Reverse Engineering Specific Objects
      • Inference Table for Reverse Engineer
    • Save Database Queries to a Trace File
    • Select Model Details
    • Select the Reverse Engineering Options
    • Connect to a Database and Reverse Engineer
    • Reverse Engineer Processing Errors
    • Troubleshoot Reverse Engineered Models
      • How to Add Naming Standards
      • Unable to use a Reserved Word
  • Naming Standards
    • Open NSM Option Editor from Model Explorer and Define Naming Standards for a Logical Model
    • Open NSM Option Editor from Model Explorer and Define Naming Standards for a Physical Model
    • Create Glossary Words and Abbreviations
    • Import Words and Abbreviations into the Naming Standards Glossary
    • Import from a Previous Version
  • Model Object Naming Preferences
    • Model Object Naming Preferences
    • Model Naming Options
    • Enforce Rename of a Duplicate Name to Ensure Unique Naming
    • Use Unique Naming Options
    • Set Preferences for Duplicate Object Names
    • Set Preferences for Case Conversion of Logical Model Object Names
    • Set Preferences for Case Conversion of Physical Model Object Names
    • Set the Maximum Length for Physical Model Object Names
    • Set the Maximum Length for Logical Model Object Names
    • Allow Special Characters in the Physical Model Object Name
    • Set Preferences for Special Characters in Derived Physical Model Object Names
    • Apply Naming Standards to a Model
    • Change the Macro to Convert Names
    • Remove Vowels from Physical Model Object Names
    • Add a Prefix to Physical Model Object Names
    • Add a Suffix to Physical Model Object Names
    • Reset Physical Model Object Names to Logical Names
    • Use Macros to Create Logical to Physical Relationship Names
    • Name Mapping Conventions Using Macros
    • Name Hardening Wizard
      • Override Name Inheritance
      • Unharden Object Names
      • Harden or Unharden Object Names Selectively
  • Data Types and Data Type Standards
    • Logical Data Types and Domains
    • Define Data Type Standards from Model Explorer
    • Create a Mapping
      • Data Type Mapping Rules
    • Apply Data Type Standards to a Model
    • Import Data Type Standards
  • Design Layers
    • Split a Logical/Physical Model
  • Derive a Model
    • Design Layers and Model Derivation
    • How to Derive a Model
    • Select the Source Model for a Derived Model
    • Select the Target Model for a Derived Model
    • Select the Types of Objects to Derive
    • Option Sets
    • Select Source Model Objects for the Derived Model
    • Apply Naming Standards to the Derived Model
  • How Complete Compare Works
    • Complete Compare
    • Complete Compare Wizard Summary
      • Select the Left Model in the Complete Compare Wizard
      • Select the Right Model in the Complete Compare Wizard
      • Type Resolution Wizard
      • Select Objects and Properties By Type
      • Refine the Criteria for Object Comparison in the Left Model
      • Refine the Criteria for Object Comparison in the Right Model
      • Filter By Owner Name
      • Select Advanced Options to Refine the Compare Criteria
    • Allow Demand Loading
    • Resolve Differences Dialog
      • Resolve Differences Standard Toolbar
      • Resolve Differences Impact Analysis Toolbar
      • Resolve Differences - Known Differences Toolbar
      • Resolve Differences - Standard Filters Toolbar
      • Resolve Differences Navigation Toolbar
      • Import or Export Items in the Resolve Differences Dialog
      • How you can generate an Alter Script in the Resolve Differences Dialog
      • Match Objects in the Resolve Differences Dialog
      • Unmatch Objects in the Resolve Differences dialog
      • Save a Complete Compare Snapshot
      • Load a Complete Compare Snapshot
      • Manage Model Snapshots
      • Search the Resolve Differences Dialog
      • Read-only Action Log
      • Message Log
      • Generate a Comparison Report
      • Explain Differences in the Resolve Differences Dialog
    • Manage Complete Compare Option Sets
      • Save a Complete Compare Option Set
      • Update or Modify a Complete Compare Option Set
    • Save a Complete Compare Session
    • Open a Complete Compare Session
    • Complete Compare Examples
      • Compare Two Data Models
      • Compare a Data Model and a Script File or Database
      • Compare a Local Model and a Large Database
      • Compare Two Databases
    • The DB Sync Button
    • Dangling Relationships in Synchronization
  • Add or Link a Model Source
    • Model Sources
    • How to Add a Model Source
      • Select a Model Source for the Current Model
      • Select Objects to Be Filtered from the Model Source
      • Select Objects From the Model Source
      • Set Naming Standards Options
    • Remove a Model Source
    • View or Change a Model Source
    • Enter a Model Source Description
    • Enter Model Source User-Defined Property Values
    • Change Model Source Naming Rules
    • Delete a Model Source
    • Synchronize a Model with a Model Source
    • Review the Last Synchronization Date for a Model Source
    • Synchronize Models
    • How to Synchronize Models
      • Select a Model Source for the Synchronization
      • Select Objects to Be Filtered During Synchronization
      • Select Objects from the Current Model for Synchronization
      • Select Objects from the Source Model for Synchronization
      • Set Additional Synchronization Options
    • How to Link Model Sources
      • Link Objects Between Models
      • Select the Model Objects From the Source Model to Link
      • Select the Object Types You Want to Link Between the Source and Target Model
      • Select the Object Filter Options for Your Source Model
      • Select Naming Standards to Link to the Target Model
    • How DB Sync Works
      • Load or Select a Model for Synchronization
      • Select Filters for Synchronization
      • Refine the Criteria for Object Comparison
      • Select Additional Filters for Synchronization
  • Working with Transformations
    • Overview of Transformations in r8
      • Impact of the r8 Transformations Functionality
      • Changes to the User Interface
      • Migrating r7.x Models to r8 Models
      • Saving a r8 Model with Transformations to a Previous Version
    • Refining a Model Using Transformations
    • Apply Transformations to Model Objects
      • The Transformations Toolbar
    • Using a Transformation to Resolve a Many-to-Many Relationship
      • Resolve a Many-to-Many Relationship with a Transformation
    • Role of Transformations in Supertype-Subtype Relationships
      • Create a Supertype-Subtype Identifying Relationship Using a Transformation
    • Using a Transformation to Roll Up a Subtype Relationship
      • Roll Up a Subtype Relationship with a Transformation
    • Using a Transformation to Roll Down a Subtype Relationship
      • Roll Down a Subtype Relationship with a Transformation
    • Using a Transformation to Vertically Partition a Table
      • Vertically Partition a Table with a Transformation
    • Using a Transformation to Horizontally Partition a Table
      • Horizontally Partition a Table with a Transformation
    • Using the Two Table Roll Down Transformation
      • Roll Down and Denormalize Two Tables with a Transformation
    • Using the Two Table Roll Up Transformation
      • Roll Up and Denormalize Two Tables with a Transformation
  • The Link Wizard
    • Link Objects
    • Use the Link Wizard to Synchronize Columns or Attributes
    • Enter a Name and Synchronization Direction for the Link Object
    • Select a Target Column or Attribute for the Link Object
    • Select Properties to Synchronize Between the Link Objects
    • Change Properties to Synchronize Between Linked Objects
    • Save Your Property Selections in the Link Wizard as an Option Set
    • Link Wizard Example
  • Import and Export Data
    • Import and Export of Data Model Data
    • How to Use the Metadata Integration Wizard
      • Set Options for Import from External Format
        • Disabled Location Field for Certain Import Bridges
      • Set Options for Export to External Format
        • Disabled Location Field for Certain Export Bridges
      • Status Log Dialog
      • Publish a Model to CA ERwin Web Portal
  • Data Warehouse Sources
    • Data Warehouse Sources
    • Create a Data Warehouse Source
    • Delete a Data Warehouse Source
    • Import a Data Warehouse Source
    • Add a Table to a Data Warehouse Source
    • Add a Column to a Data Warehouse Source
    • Remove a Table from a Data Warehouse Source
    • Remove a Column from a Data Warehouse Source
    • Enter a Data Warehouse Source Definition
    • Data Warehouse Source Selector Dialog Options
    • Overview of Importing Comma-Separated Values (CSV) Files
    • CSV File Table Description Format
    • CSV File Column Description Format
    • Sample Data Warehouse CSV Source File
  • Volumetrics
    • Volumetrics in a Data Model
    • Calculate Table and Database Size
    • Define a Volumetrics Report
    • Set Volumetrics Database Parameters
    • Specify Volumetric Information for a Table
  • Macros
    • Macros in Declarative Statements
    • Macros in Arithmetic Statements
    • Macros in Branching Statements
    • Macros in Boolean Statements
    • Macros in Looping Statements
    • Macros for Communicating with External Files
    • Macros and Generalizing Behavior Among Objects
    • Macros and Generalizing Behavior Across Databases
    • Macros in Domains
    • Macros for Name Mapping
  • Macro Toolbox
    • Entity Macros
      • %Action
      • %Actions()
      • %Atts()
      • %C2PVerbPhrase
      • %CreateOrReplace
      • %CustomTriggerDefaultBody
      • %CustomTriggerDefaultFooter
      • %CustomTriggerDefaultHeader
      • %EntityId
      • %EntityName
      • %EntityProp()
      • %ErwinRelationInfo
      • %ForEachAtt()
      • %ForEachAttribute()
      • %ForEachChildRel()
      • %ForEachColumn()
      • %ForEachEntity()
      • %ForEachIndex()
      • %ForEachIndexMem()
      • %ForEachKey()
      • %ForEachKeyMem()
      • %ForEachLogEntity()
      • %ForEachMatView()
      • %ForEachTable()
      • %ForEachView()
      • %ForEachViewColumn()
      • %IndexGenerated
      • %IndexName
      • %IndexProp()
      • %IndexType
      • %JoinPKPK()
      • %KeyGroupProp()
      • %KeyName
      • %KeyType
      • %NK()
      • %NKDecl()
      • %New
      • %Old
      • %P2CVerbPhrase
      • %PK()
      • %PKDecl()
      • %ParamDecl()
      • %RefClause
      • %Scope
      • %SetPK()
      • %SubjectAreaProp()
      • %TableCheckConstraintName
      • %TableName
      • %TableOwner
      • %TableProp()
      • %TemplateName
      • %TriggerFireOrder
      • %TriggerName
      • %TriggerSeq
      • %TriggerWhen
      • %UpdatePK()
      • %ViewName
      • %ViewOwner
    • Relationship Macros
      • %Cardinality
      • %Child
      • %ChildAtts()
      • %ChildFK()
      • %ChildFKDecl()
      • %ChildNK()
      • %ChildNKDecl()
      • %ChildPK()
      • %ChildPKDecl()
      • %ChildParamDecl()
      • %EntityId
      • %EntityName
      • %ForEachFKAtt()
      • %ForEachFKAttribute()
      • %ForEachFKColumn()
      • %JoinFKPK()
      • %JoinPKPK()
      • %NotnullFK()
      • %Parent
      • %ParentAtts()
      • %ParentCols()
      • %ParentNK()
      • %ParentNKDecl()
      • %ParentPK()
      • %ParentPKDecl()
      • %ParentParamDecl()
      • %PhysRelName
      • %RelId
      • %RelIsNonull
      • %RelLogProp()
      • %RelPhysProp()
      • %RelRI()
      • %RelTemplate
      • %RelType
      • %SetFK()
      • %SetPK()
      • %TriggerRelRI()
      • %VerbPhrase
    • Attribute Macros
      • %AttDatatype
      • %AttDef
      • %AttDefault
      • %AttDomain
      • %AttFieldName
      • %AttFieldWidth
      • %AttId
      • %AttIsFK
      • %AttIsPK
      • %AttIsRolenamed
      • %AttName
      • %AttNullOption
      • %AttPhysDatatype
      • %AttProp()
      • %AttValidation
      • %AttributeDatatype
      • %AttributeDefault
      • %AttributeNullOption
      • %AttributeValidation
      • %ColDomain
      • %CollsFK
      • %CollsPK
      • %ColName
      • %ColProp()
      • %ColWidth
      • %ColumnCheckConstraintName
      • %ColumnComment
      • %ColumnDatatype
      • %ColumnDefault
      • %ColumnDefaultConstraintName
      • %ColumnNullOption
      • %ColumnPhysDatatype
      • %ColumnProp()
      • %ColumnValidation
      • %OwnerEntity
      • %OwnerTable
      • %ParentAtt()
      • %ParentAttribute()
      • %ParentColumn()
      • %ViewColumnName
    • Constraint Macros
      • %DefaultName
      • %DefaultValue
      • %DomainComment
      • %DomainDatatype
      • %DomainDef
      • %DomainDefault
      • %DomainIsRequired
      • %DomainLogDatatype
      • %DomainLogDefault
      • %DomainName
      • %DomainNullOption
      • %DomainPhysDatatype
      • %DomainPhysDefault
      • %DomainValidation
      • %Fire
      • %ForEachDefault()
      • %ForEachDomain()
      • %ForEachValidValue()
      • %ForEachValidation()
      • %ValidValue
      • %ValidValueDef
      • %ValidationHasValidValues
      • %ValidationLogicalName
      • %ValidationName
      • %ValidationRule
    • Miscellaneous Macros
      • %%
      • %:
      • %<arithmetic op>(,)
      • %<comparison op>(,)
      • %=
      • %And(,)
      • %CLRMethodSpecifiers
      • %Concat
      • %CurrentDatabase
      • %CurrentFile
      • %CurrentServer
      • %CurrentUser
      • %DBMS
      • %DBMSDelim
      • %DBMSTriggerDelim
      • %DatabaseEvent
      • %DatatypeName()
      • %DatatypeScale()
      • %DatatypeWidth()
      • %Datetime
      • %DDLEvent
      • %Decl
      • %DiagramProp()
      • %File()
      • %FunctionReturn
      • %If()
      • %Include
      • %Len
      • %LookUp
      • %Lower
      • %Max()
      • %Min
      • %Not()
      • %Or(,)
      • %Parameters
      • %ProcedureOwner
      • %ProcedureProps
      • %SQLServerWithOptions
      • %ServerEvent
      • %Substitute
      • %Substr()
      • %Switch()
      • %TableOwnerIgnoreOption
      • %TeradataCreateReplace
      • %TeradataExternalMethodSpecifiers
      • %TeradataProcedureProps
      • %Upper
    • Macro Syntax
    • Macro Variables
    • DBMS Support for Macros Used in the Physical Model
    • Macro Documentation
    • Nesting Macros Limitations
• Reports
  • Create Reports Using Report Designer
    • The Filter By Option
    • Report Designer Features
    • Subject Area Reports
    • Change the Logo on the HTML Report
  • Use Crystal Reports With CA ERwin Data Modeler
    • The Report Viewer
    • Export a Report from the Report Viewer
    • Print a Report from the Report Viewer
  • Standard Reports
  • View Pinned Reports
  • The Query Tool
    • Create a Query
    • Open a Query
    • Save a Query
    • Execute a Query
    • Execute a Query Against a Database
    • Execute a Query Against ERwin ODBC
    • Change the Instance of an ODBC Connection
    • Restrict Row Count in Query Results
    • Save a Result Set to a CSV File
  • Using the Bulk Editor to Create a Report
  • Generate the Current Diagram Picture
  • Generate Multiple Diagram Pictures
• Working on a Mart
  • The Administrator's Tasks
    • Microsoft SQL Server 2005 Permissions
    • Specify Use of Foreign Characters With Microsoft SQL Server 2000
    • Specify Use of Foreign Characters With Microsoft SQL Server 2005
  • Connect to Mart
    • SSL Security Certificate
    • Mart Architecture
    • Disconnect from Mart
    • Retrieve Forgotten Mart Password
  • Sessions
    • Types of Sessions and Statuses
    • Terminate Inactive or Closed Sessions
  • Model Lock
    • Lock a Catalog Entry
    • Lock Behavior
  • Open a Model or a Model Version from the Mart
  • Save or Close a Model
    • Save a Model to Mart
    • Save a Mart Model Offline
    • Save a Model to a Different Name
    • Close a Model
    • Rebind an Offline Mart Model to the Mart
    • Disconnect from the Mart
  • Refresh Your Copy of a Model
  • Review Model Changes
  • Catalog Manager
    • Copy a Library or Model
    • Model Versions
    • Create a Delta Version
    • Create a Named Version
    • Compare Model Versions
    • Delete Versions
  • Workgroup Modeling Reports
    • Generate a Global Report
    • Generate a Model Validation Report
    • Generate a Diagram Report
    • Generate a Model Lock Report
    • Generate a Report on Model Contents by Class
    • The Report Viewer
• Change Management in CA ERwin Data Modeler Workgroup Edition
  • Three-Way Merge
  • How to Merge Model Objects
  • Model Merge Options
  • Merge Two Versions of a Model
  • Merge Two Independent CA ERwin Data Modeler Models
  • Resolve Security Violations
  • Reconcile Model Differences
    • Difference Reconciliation Standard Toolbar
    • Difference Reconciliation Impact Analysis and Reporting Toolbar
    • Difference Reconciliation Known Difference Toolbar
    • Difference Reconciliation Navigation Toolbar
    • Difference Reconciliation Standard Filters Toolbar
    • Filter the Change List
    • Search for Changes in a Change List