SHOW COLUMNS

NOTE! For improved performance, execute this command in the mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.

SHOW COLUMNS lists the columns available from an item—either sources, materialized views, or non-materialized views.

Syntax

SHOW COLUMNS FROM item_ref LIKE pattern WHERE expr
Field Use
item_ref The name of the item whose columns you want to view. These can be sources or views (either materialized or non-materialized).

Details

Output format

SHOW COLUMNS’s output is a table, with this structure:

+---------+------------+--------+
| name    | nullable   | type   |
|---------+------------+--------|
| ...     | ...        | ...    |
+---------+------------+--------+
Field Meaning
name The name of the column
nullable Does the column accept null values?
type The column’s type

Rows are sorted by the order in which the fields are defined in the targeted source, view, or table.

Examples

SHOW SOURCES;
   name
----------
my_sources
SHOW COLUMNS FROM my_source;
  name  | nullable | type
---------+----------+------
 column1 | NO       | int4
 column2 | YES      | text
Back to top ↑