Can any one know how can I describe a table to get the table structure and the relationships. Relationships in the sense which column is used as primary key or foreign key in a particular table.
Desc table provides only column details. I executed below query but it gives only followings.
desc award_reason
Name Null Type
--------------- -------- ------------
AWARD_REASON_ID NOT NULL NUMBER(11)
REASON_TYP NOT NULL VARCHAR2(35)
SORT_ORDR NOT NULL NUMBER(2)
ACTIVE NOT NULL NUMBER(1)
Here 'award_reason' is a synonym.
Can any one help me on this please.