Describe Table Tool
The Describe Table Tool allows users to show detailed information about a table or view.
The Describe Table tool shows table or view information in three tabs. The first tab is the columns tab and provides the following information:
Primary Key Status
Foreign Key Status
The second tab is the primary and foreign key tab and displays detailed information on the fields and tables referenced by the primary and foreign keys.
The third tab displays the Create Table DDL for the particular table. If there are foreign keys in the table, it also displays the Alter Table DDL used to generate the foreign keys.