VistaDB 6
VistaDB / Developer's Guide / How To Perform Common Tasks / Build and Visualize Foreign Key References / Adding a Foreign Key
In This Topic
    Adding a Foreign Key
    In This Topic

    Creating using SQL Syntax

    The dialog below is the same as executing the following SQL syntax.

    ALTER TABLE [Timesheets]
    ADD
    CONSTRAINT [FK_Timesheet_Employees] FOREIGN KEY ([EmployeeID])
    REFERENCES [Employees] ([EmployeeID])
    ON UPDATE CASCADE
    ON DELETE CASCADE;

    Creating using Data Builder

    Adding a Foreign Key to a table is performed through the Data Builder by right clicking on the Foreign Keys folder under the table you wish the key to be applied and selecting Create Foreign Key. This will bring up a dialog that allows you to edit the settings of the Foreign Key.

    See Also