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 a Table in SQL Azure

Use the SQL Azure Table Editor to define the tables in a database in a SQL Azure physical model.

To define a table in SQL Azure

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.

   Physical Name

   Specifies the physical name of the table. Change the physical name of the table in this field.

   Note: The name you enter here is automatically updated in the Physical Name field in the General tab.

   Schema

   Specifies the schema of the database to which the table belongs. Select the schema from the drop-down list.

   Physical Only

   Specifies whether the table is suppressed from a logical model and appears in a physical model only.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. (Optional) Click the General tab and enter the physical name of the table.

   Note: The name you enter here is automatically updated in the Navigation Grid.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify validation rules in the Validation tab
   • Define table permissions using the Permission tab
   • Define table volumetrics in the Volumetrics tab
   • Work with style sheets which are used to format the font and other graphical themes used in the display of the table in the Style tab
   • Specify the icon style to use for the table in the Icon tab
   • Specify the order of DDL generation in the Object Creation Order tab
   • View where the table is used within the model in the Where Used tab
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the table.
6. (Optional) Click the UDP tab to work with user-defined properties for the table.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The table is defined and the SQL Azure Table Editor closes.

More information:

Define Validation Rule Usage for a SQL Azure Table

Define SQL Azure Permissions

Add a Comment in a Property Editor

Define Volumetrics for a SQL Azure Table

Define the Style for a Table, View, or Column

Specify the Icon to Display for a Table or View

Change the Object Creation Order for Tables or Views

View the Where Used Information for a Physical Object

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History