SHOW COLUMNS fetches all column names of a given table and displays their column name and data type. The column names are listed in alphabetical order. More details can be fetched by querying the table.

table_name

table_schema

The name of the schema the tables are appropriate to.

The optional clause indicates which column names to match. It takes a string pattern as a filter and has an equivalent behavior to LIKE (ILIKE).

WHERE

The optional WHERE clause defines the condition to be met for a row to be returned.