SHOW COLUMNS¶
SHOW COLUMNS displays information about columns in a given table.
Table of contents
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.