The Table properties view contains the following tabs:
On this page, the name, the schema, and the description of the selected table are displayed. These values are taken from the source of the table. This can be a database or a physical data model. Additionally, you can change the alias name of the table.
On this page, the columns of the selected table are displayed. For each column, the name, the descriptive name, the data type, the length, the scale, and the key constraints, are provided. If a primary key or foreign keys are available, they are displayed with the referenced tables. If the table that is referenced by the key constraint is not included in the input model but only in the database, it is not shown.
You can view sample contents for columns by selecting the columns and clicking Explore the Selected Columns.
You can change the descriptive name of a column by double-clicking the existing name and replacing it with a new name. The descriptive name must be unique within the table.
On this page, information about the primary key and the foreign keys of the table is displayed.
For the primary key, the name of the primary key and the list of columns that are members of the primary key is shown.
The list of foreign keys and the referenced tables is provided. By selecting a foreign key, the name of the foreign key, the referenced table, the foreign key members, and the referenced members are shown. If referenced tables or referenced members of a foreign key are only available in the database and not in the input model, they are not shown.
On this page, you can browse the joins of the selected table. For each join, the join name, the join type, and the joined tables are displayed.
You can create a new join between the current table and another tables by clicking Create a New Join in the tool bar.
You can edit an existing join by selecting the join and clicking Edit the Selected Join on the toolbar or by double-clicking the join. You can delete joins by selecting them and clicking Delete Selected Joins, or you can delete all joins by clicking Delete All Joins.