SHOW COLUMNS

SHOW COLUMNS displays information about columns in a given table.

Table of contents

• Synopsis

• Description

• Parameters

• Clauses

  • LIKE

  • WHERE

Synopsis

SHOW COLUMNS { FROM | IN } table_name [ FROM | IN table_schema ] [ LIKE 'pattern' | WHERE expression ]

Description

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 information_schema.columns table.

Parameters

table_name

The name of the table of which the column information is printed.

table_schema

The name of the schema the tables are appropriate to.

If no schema name is specified the default schema is set to doc.

Clauses

LIKE

The optional LIKE 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.