SHOW COLUMNS
Use the SHOW COLUMNS command to view columns in the specified table, source, sink, view or materialized view.
Syntax
SHOW COLUMNS FROM relation_name [ LIKE_expression ];
Parameters
| Parameter or clause | Description |
|---|---|
| relation_name | The name of the table, source, sink, view, or materialized view from which the columns will be listed. |
| LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
Examples
SHOW COLUMNS FROM taxi_trips;
