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

Define Volumetrics for a SQL Azure Table

In a model based on a SQL Azure target server, you use the SQL Azure Table Editor to define volumetrics for a table.

To define table volumetrics for a SQL Azure table

1. Click Tables on the Model menu.

   The SQL Azure Table Editor opens.

2. Select the table in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

3. Click the Volumetrics tab and work with the following options:

   Initial Row Count

   Defines row count for the table. Enter a value in the field.

   Max Rows

   Defines row sizing for the table. Enter a value in the field.

   Growth By Month

   Defines growth increments for the table. Enter a value in the field.

4. Click Close.

   Volumetrics are defined for the table and the SQL Azure Table Editor closes.