Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › SQL Azure Common Functionality › Define the SQL Code for an Object in a SQL Azure Property Editor

Define the SQL Code for an Object in a SQL Azure Property Editor

You can define the SQL code to use for actions of certain SQL Azure objects using the Code tab in the object's property editor. You can also edit SQL code related to certain SQL Azure objects. For example, if you click the Code tab in the SQL Azure Table Trigger Editor, you can define the SQL code to use to implement the table trigger, and have the option to edit the table trigger's SQL code.

To define the SQL code for an object in a SQL Azure property editor

1. Open the property editor for the object for which you want to define the SQL code, and select the object in the Navigation Grid.
2. Click the Code tab and work with the following options:

   Code Type

   Identifies the code type of SQL for the SQL Azure object with which you are working.

   SQL

   Defines the SQL code. You can edit the SQL code in this area using the icons 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.

3. Click Close.

   The SQL code is defined for the selected object and the property editor closes.