Most of the tables in our system (over 90%) do not have Metadata describing the foreign keys.
When you run the Foreign key discovery, it only finds foreign keys from the Metadata.
We have several table that keep the foreign key information about the rest fo the tables.
Is there an automated way that we can set the Foreign key and primary key information on these tables?
We can write code to do this if there is a way that something we write will add the foreign key information to the datamodeler.