SHOW COLUMNS

Use the SHOW COLUMNS command to list the columns in a Refinery view including their data type and other attributes.

Synopsis

SHOW COLUMNS FROM [schema.]table [LIKE pattern]

Specify a pattern in the optional LIKE clause to filter the results to the desired subset. For example, the following query allows you to find columns ending in key:

Examples