Physical Modeling › Tables › Tables Dialog

Tables Dialog

Use the following options and tabs in the Tables dialog to add a new table or modify the properties of an existing table. Available options and tabs will vary based upon your target DBMS and the model properties you select in the Model Properties dialog.

Table

Lets you select a table for which you can view properties.

Name

Lets you specify the table name.

Owner

Lets you specify the owner name for the table.

Physical Only

Specifies to display the table in the physical model only. If you clear this check box, the table displays in the logical model as an entity.

Generate

Specifies to generate a CREATE TABLE statement for the table in the schema generation script.

DB Sync

Lets you to start the DB Sync wizard so you can synchronize the tables defined in your data model with the database stored on the server.

Dimensional

Lets you specify dimensional modeling table roles and document how to update information in the data warehouse if the table has a dimension role.

Note: This tab is only available if you selected the Dimensional check box in the Model Properties dialog.

Data Movement

Lets you document data movement rules for a table.

Note: This tab is only available if you selected the Data Movement check box in the Model Properties dialog.

Physical Props

Lets you view and modify physical storage properties for a table and associate tables to predefined physical storage devices.

Comment

Lets you enter a comment for a table.

Volumetrics

Lets you enter sizing information, including growth estimates, for a table.

Note: Use the Volumetrics dialog to view and report table and database size calculations.

UDP

Lets you enter user-defined property values for a table.

History

Lets you view the history of a table.

Validation

Specifies to attach validation rules to a table.

Synonym

Lets you specify synonym names for a table.

Alias

Lets you specify alias names for a table.

Alias & Synonym

Lets you specify both alias and synonym names for a table.

Note: When you select a physical storage object in which to store a table, the default or current parameters for that object appear with the table. Therefore, when you view a table in the Tables dialog, you can see the associated table name and the physical object in which the table is stored, and you can modify the parameters for that physical storage object. You can also increase or decrease the space available for the selected table, create space to store additional tables in the same physical object, or modify the size of storage objects as they are created.

More information:

Attach a Stored Procedure to a Table or View

Attach a Table or View to a Script

Create a Synonym for a Table

Create a Table Alias Name

Define Dimensional Modeling Table Roles

Define Data Movement Rules for a Table

Enter a Table Comment

Enter Table User-Defined Property Values

View History in a Property Editor