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.