Some table level check constraints can be transformed to arc constraint if there are foreign keys defined.Philip What does mean "Check"? Is it about check constraints defined at table/column level? Check constraint cannot be expressed as relationships. I've now discovered that the primary/foreign constraints are already assigned in the ABM schema, but the constraints in the AP schema are all "Check." Is there a way for me to see the relationships in data modeler when all column restraints are "Check?" Thanks again. There's no data pulling up in the Discover Foreign Keys until I go to the tables and designate a column as a primary key in the data modeler. There's more detail on the discovery options in the Help for the "Create discovered foreign keys" panel.David Right-click over the node for the Relational Model in the Browser, and select Discover Foreign Keys.This can be used to find hidden foreign key relationships in the model, based on column names, and create the relevant Foreign Keys. ![]() That's probably because the Foreign Key constraints are not set up in the database.There's a Discover Foreign Keys option in Data Modeler. ![]() ![]() When I import the AP or GL schema it shows up as a bunch of stand alone tables with no relationships between them. ![]() Why no relationships showing after importing certain schema? For example, when I import the ABM schema and look at the relational model it shows the relationships between the tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |