Model Parts, Diagrams, Dictionary Items, and Properties > Dictionary items > Table (dictionary item)
Table (dictionary item)
For automation interface information about a Table, see Table (automation interface).
A Table is an organization of data, in a Database, that has a specific number of Columns and an arbitrary number of rows. Within a Table, each Column must be unique. A Table is accessed through its prime key, which is made up of one or more Columns.
You can create a Table through the context menu of a Package: right-click the Package, point to New, point to Proprietary, point to Data Model, and then click Table. You can also create a Table on a Table Relationships Diagram.
You can use Storage Mapper to create Tables from Classes defined in the model. For more information about Storage Mapper, see Storage mapping overview (Storage Mapper).
When used on a diagram, a Table's notation is as follows:
For information about the View Options available for this symbol, see Table view options — table relationship diagram.
In the Modeler panes, a short-cut symbol on the Table's icon indicates that the item is a stub.
On a Table Relationships Diagram the View Options for a Table allow you to show or hide its Columns.
The following sections provide information about how a Table is used in the model. For more information about a property, item, model part or diagram, click it.
In addition to the standard properties, a Table has these properties:
Column Order (Col Order through the automation interface)
Trigger Sql
Owned by
Dependency- The Dependency is owned jointly by the Table and the other associated item. The access permissions you have to a Dependency are determined by the access permissions of the dependent item.
Relationship- The Relationship is owned jointly by the Table and the associated Table. The access permissions you have to a Relationship are determined by the access permissions you have to the child Table.
Defined in these parts of the model
Data Model
Shown on these diagrams
Table Relationships Diagram
Variant Diagram
For information about how the View Options affect the presentation of Tables, see Table View Options Relationship Diagram.
Can be linked to these dictionary items
In addition to the owning Package or Model, a Table can be linked to the following items:
Database- The Table is stored in the linked Database.