SHOW COLUMNS
On this page
Show the list of columns within a given table.
Syntax
SHOW [FULL] COLUMNS {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]
Remarks
-
LIKE
'pattern' can be used to filter the list by name.SQL LIKE clause. -
See the Permission Matrix for the required permission.
Output
Column |
Description |
---|---|
|
Field name |
|
|
|
Whether this column allows nulls |
|
An attribute or attributes that uniquely identify table rows. |
|
Default value, if applicable |
|
Additional information |
Example
SHOW COLUMNS IN mytbl;+----------+------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+----------+------------+------+-----+---------+-------+| seq | int(11) | YES | MUL | NULL | || state | int(11) | YES | | NULL | || st_case | varchar(8) | YES | | NULL | || veh_no | varchar(2) | YES | | NULL | || drimpair | varchar(2) | YES | | NULL | |+----------+------------+------+-----+---------+-------+5 rows in set (0.00 sec)
Last modified: May 22, 2023