Link Search Menu Expand Document

SHOW COLUMNS

Lists columns and their properties for a specified table. Returns <table_name>, <column_name>, <data_type>, and nullable (1 if nullable, 0 if not) for each column.

Syntax

SHOW COLUMNS <table_name>;
Parameter Description
<table_name> The name of the table to be analyzed.

Example

SHOW COLUMNS prices;

Returns

------------+-------------+-----------+----------+
| table_name | column_name | data_type | nullable |
+------------+-------------+-----------+----------+
| prices     | item        | text      |        0 |
| prices     | num         | int       |        0 |
+------------+-------------+-----------+----------+