Foreign key inheritance

Syntho automatically inherits all foreign keys that are stored in your source database. This means that the generated database will respect the foreign key constraints of your source database.

Foreign keys can be viewed when selecting the Foreign keys tab on the Job configuration screen and after unchecking the box Show manually added foreign keys only.

Limitations

• Composite foreign keys are not supported in the following situation:

  • when two or more columns that make up the composite foreign key also serve as a composite primary key in a referred other table, AND

  • the key generation method is set to generate