

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in 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
- Click Tables on the Model menu.
The SQL Azure Table Editor opens.
- 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.
- (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.
- Work with the other tabs in the editor to access additional design features, for example:
- Preview the forward engineering script for a table in the SQL tab.
- Specify validation rules in the Validation tab.
- Define table permissions using the Permission tab.
- Work with style sheets to format the font 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.
- (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
- (Optional) Click the Where Used tab to view where the object is used within the model.
- (Optional) Click the UDP tab to work with user-defined properties for the object.
- (Optional) Click the History tab to view the history information for the object.
- (Optional) Click the Notes tab to view and edit user notes.
- 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
Copyright © 2017 erwin Inc.
All rights reserved.
 
|
|