Creating Models › Creating a Physical Model › Tables

Tables

In the physical model, you can create the following types of tables:

• Independent table
• Dependent table

A table box has a horizontal line, which divides the box. You can enter the primary key above the line and non-keys below the line. You can choose to migrate keys to either the primary or non-key area of the box.

When you add a table, the table type is determined based on its relationship. For example, when you initially place a table into a model, it is represented as an independent table. When you connect the table to another table using a relationship, a table is designated as independent or dependent based on the relationship type. If a table is a child table in an identifying relationship, it appears on the diagram window as a dependent table (table box with rounded corners). All other tables appear as independent tables (table box with square corners).

More information:

Table Addition Methods

Tables in the Model Explorer

Tables and Validation Rules

Table Synonym Names