DESCRIBE

description

This statement is used to display schema information for the specified table.

Syntax:

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

Note:

If ALL is specified, the schema of all indexes(rollup) of the table is displayed

example

  1. Show Base table schema

    DESC table_name;
  2. Show the schema of all indexes in the table

    DESC db1.table_name ALL;

keyword

DESCRIBE,DESC