So, I’m trying to visualize a database, and I have some tables put together which consist of a mix of object-oriented and relational; just trying to tie them together.
My issue is, I can’t seem to find any info on the notation/legend – and I’m having trouble figure out what all the (Ix#)’s are. For Example, in the top left corner table “NC_PO_ACTIONS,” for the Column ACTION_ID: I can see it’s a primary key, but not sure what (Ix3) means…
I’ve looked at all the user guides I could find, as well as the help menu within Toad.
Advertisement
Answer
Yes, those are indexes. On the left side choose the Diagram tab. You can expand the tables there and see additional information including the indexes. You can also press F4 when an object is selected to get Toad’s popup Describe window which will contain much more information for the selected object.
