SHOW COLUMNS

Use the SHOW COLUMNS command to view columns in the specified table, source, sink, view or materialized view.

DESCRIBE <relation_name> provides similar functionality, but with more detailed information.

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;