Archive - Add Virtual Key

Archive - Add Virtual Key

Add a virtual foreign key relationship so tables can be cross-referenced.  Virtual foreign keys are created on a child table and link back to the parent table.  The column in both the parent and child table must follow these rules:

  • Numbers must be the same size and sign (for example positive).
  • String arrays do not need match in length.
  • Character arrays must use the same character sets.

Multiple relationships can be added or removed with the Add and Delete buttons. Changes do not take effect until you click the OK button.

Table Name

The parent table name for the selected table in the Content tab of the Subclient Properties dialog box.

Dependent Table Name

A list of all the dependent (child) tables for the selected table. 

Foreign Key

This defines relationship between the tables. The following are available:

  • RESTRICT
  • CASCADE
  • SET NULL
  • NO ACTION

Column

This box lists all the columns contained in the Dependent (child) table.

Column

This box lists all the columns contained in the Table (parent table).

Add

Click this button to add the relationship between the selected Columns. Changes do not take effect until you click the OK button.

Delete

Select a Foreign Key from the Existing Foreign Keys box and click this button to remove the relationship. Changes do not take effect until you click the OK button.

Existing Foreign Keys

This box lists all foreign key relationships that exist.  Select the Virtual check box to add a virtual foreign key.