Physical Modeling › Oracle Physical Property Editors › Edit the User Defined SQL Code

Previous Topic: View SQL Code for a Physical Object

Next Topic: Add an Expression to an Oracle Table or Materialized View Index

Edit the 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. The following options are available for this tab:

User-Defined SQL

Select the 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.