Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Index Properties › Define a Table Index in SQL Azure › Define Options for a SQL Azure Table Index

Define Options for a SQL Azure Table Index

Use the SQL Azure Table Index Editor to define advanced options for table indexes in a SQL Azure physical model.

To define options for a table index in SQL Azure

1. Right-click a table index in the Model Explorer and click Properties.

   The SQL Azure Table Index Editor opens.

2. Select the table from the Table drop-down that contains the index that you want to define.
3. Select the index in the Navigation Grid that you want to define.

   Note: Use the Enter filter text box to filter a very large list of indexes to quickly locate the one for which you want to define options.

4. Click the Options tab and work with the following options:

   Ignore Duplicate Keys

   Specifies the ignore duplicate keys value for the current index type. Select the option from the drop-down.

   Drop Existing

   Specifies whether to use the drop existing option. Select the option using the check box.

   No Recompute

   Specifies the no recompute value for the current index type. Select the option from the drop-down.

   Online

   Specifies the online value for the current index type. Select the option from the drop-down.

5. Click Close.

   Options are defined for the table index and the SQL Azure Table Index Editor closes.