I'm using Toad for Oracle v12.0.0.61 with admin module. the database i'm interested in has 61 "views" I selected all views, right clicked and chosen ER Diagram Toad created small UML diagram for each table listing the table name and all their columns, but there are no indication of their primary keys or foreign keys and the relationships between them. Even if I choose one specific table (main one), and right click on it and choose ER diagram, choosing say 5 level of details, it creates one diagram only for one table without all the other information. Am I missing any step here or is this related to the level of access I have been given?
Thank you
Views don't have keys. Views are just canned SQL queries.
Best of luck.