DESCRIBE

Name

DESCRIBE

Description

This statement is used to display the schema of the specified table

Syntax:

DESC[RIBE] [db_name.]table_name [ALL];

Note:

1. If ALL is stated, the schemas of all indexes (rollups) of the table will be displayed

Example

1. Display the base table schema

   DESC table_name;

2. Display the schema of all indexes of the table

   DESC db1.table_name ALL;

Keywords

DESCRIBE

Best Practice