When describing a table within Toad, it doesn’t show any key fields as defined by the tables structure within People Soft App Designer. I realize that these are two separate entities, but when a table is created based on that structure, then Toad should recognize the structure accordingly. It recognizes the Data_type, whether the field is nullable, etc. But not what the keys are.
Any ideas as to how to make this happen? Thanks!