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:

Column Name
Column Type
Column Size
Primary Key Status
Foreign Key Status
Nullablity
Scale

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.

Describe Table