Primary Key properties

These primary key properties are available when you select an individual database field.

Property

Description

Primary key (PK)

Indicates whether this field is a primary key field or one of the fields in composite primary key. Primary key field(s) should have unique value(s) in table, i.e. only one row in the table can have any particular value(s).  Iron Speed Designer generated application uses primary key to update or select record.

Virtual primary key (VPK)

Indicates whether the field should be treated as if it were a primary key for the table or view.  Zero or more fields may be selected which collectively comprise the primary key of the table (a composite key).

For additional information, see: Adding Virtual Primary Key Relationships.

Use database sequence

Indicates whether the field is automatically populated with a sequence number provided by the database.  This option applies only to Oracle databases.