Table (dictionary item)

Model Parts, Diagrams, Dictionary Items, and Properties > Dictionary items > 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, and select New > Proprietary > Data Model > 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.

Properties

In addition to the standard properties, a Table has these properties:

• Column Order (Col Order through the automation interface)

• Owner

• Trigger Sql

• Visibility

Owned by

Owns

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.

Index

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.