Physical Modeling › Common Property Pages › Define User-Defined SQL Code

Previous Topic: Select the Tables and Columns for the View or Join Index

Next Topic: View Expanded Code in a Property Editor

Define User-Defined SQL Code

The User Defined SQL tab is identical for the physical property editors that use it. Use the User Defined SQL tab to view and change a user-provided DDL statement. This user-generated script will be used in place of the forward-engineered script based on the values set.

To define user-defined SQL code

  1. Open the property editor for a physical object and select the User Defined SQL tab.

    The User Defined SQL tab opens.

  2. Work with the following features:
    User-Defined SQL

    Select the User-Defined SQL check box to change the SQL code in the SQL Statement box. Select this check box only if you want the object to contain syntax that CA ERwin Data Modeler cannot represent, for example, a UNION statement. When you select this check box, you no longer maintain references to the base tables and columns to which the object refers.

    Click an icon to cut, copy, or paste text, or to work with the Text Editor. To add an ERwin macro, click the Macro Editor icon to open the Macro Toolbox. This option is not available if the code type is Assembly.

  3. Click close.

    The property editor closes.