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 |