DISPLAYING THE TABLE STRUCTURE

DISPLAYING THE TABLE STRUCTURE

To display information about the columns defined in a table use the following syntax

Syntax:

DESCRIBE ;

This command displays the column names, the data types and the special attributes connected to the table.

Example:

Show the table structure of table EMP_MSTR

DESCRIBE EMP_MSTR;

Output:

Name                                       Null?                       Type

----------------------------------------------------------------------------

EMP_CODE                                                   VARCHAR2(5)

EMP_NAME                                                  VARCHAR2(10)

ADDRESS                                                     VARCHAR2(20)

CITY                                                               VARCHAR2(10)