Working with Data Models › Forward Engineer/Alter Script › Select Schema Generation Options › Define Schema Generation Referential Integrity Options

Define Schema Generation Referential Integrity Options

To define schema generation referential integrity options

1. Click Forward Engineer, Schema... on the Actions menu.

   The Schema Generation dialog opens on the Options tab.

2. Select the name of the current option set and choose from the following options:

   Primary Key

   CREATE/PK

   Include a primary key clause in a CREATE TABLE statement.

   ALTER/PK

   Include the PRIMARY KEY clause in an ALTER TABLE statement.

   Foreign Key

   CREATE/FK

   Include a FOREIGN key clause in a CREATE TABLE statement.

   ALTER/FK

   Include the FOREIGN KEY clause in an ALTER TABLE statement.

   ON DELETE

   Enforce the selected referential integrity option if the value is deleted in either a primary or foreign key field.

   ON UPDATE

   Enforce the selected referential integrity option if the value is updated in either a primary or foreign key field.

   UNIQUE (AK)

   Enforce the rule requiring that alternate key values must be unique.

   sp_primary key

   Include the system procedure that creates the primary key in each table.

   sp_foreign key

   Include the system procedure that creates foreign keys.

   Create Relation

   Create relation objects. This option is only available for Access.

   Delete Relation

   Delete relation objects. This option is only available for Access.

   Click Generate to start the schema generation process for forward engineering or alter script generation or OK to save the changes and close the dialog.