Description

Describes the detailed information of the specified object. DESCRIBE can be abbreviated as DESC.

Syntax

DESC[RIBE] <object_type> [EXTENDED] <object_name>
  • EXTENDED optional, using EXTENDED can display more information

Specific Syntax Reference

DESC EXTERNAL CATALOG

DESC CONNECTION

DESC SCHEMA

DESC SCHEMA

DESC SHARE

DESC VCLUSTER

DESC JOB

DESC TABLE

DESC HISTORY

DESC VIEW

DESC MATERIALIZED VIEW

DESC INDEX

DESC TABLE STREAM