Hello. I have db with many views and tables. Can I make some relations in data modeler with Views and Tables? I must set up FK and PK for my tables and views if I want to see relations? I just started with Data Modeler. Thank you for your help.
If you import Tables from your database (using Import/Data Dictionary), any Foreign Keys defined in your database will also be imported.
There's also a Foreign Key discovery tool within Data Modeler that can help you identify potential FK relationships and add them to your model.
To use this, right-click on the entry for your Relational Model in the Browser tree and select Discover Foreign Keys from the drop-down menu.
Note that Data Modeler does not currently support PKs and FKs on Views.