Commands
DESCRIBE
Use the DESCRIBE
command to view columns in the specified table, source, sink, view, or materialized view.
DESCRIBE
is a shortcut for SHOW COLUMNS.
DESCRIBE
also lists the indexes on a table or materialized view, whereas SHOW COLUMNS
doesn’t.
Syntax
Parameters
Parameter or clause | Description |
---|---|
relation_name | The table, source, sink, view or materialized view whose columns will be listed. |
Examples
After creating the table, columns, and indexes, as well as adding comments to each of them, we can use the DESCRIBE
command to see all the information in a structured format.