Show Index From Table

MariaDB [classicmodels]> SHOW INDEX FROM customers;

+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table     | Non_unique | Key_name               | Seq_in_index | Column_name            | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| customers |          0 | PRIMARY                |            1 | customerNumber         | A         |         122 |     NULL | NULL   |      | BTREE      |         |               |
| customers |          1 | salesRepEmployeeNumber |            1 | salesRepEmployeeNumber | A         |          40 |     NULL | NULL   | YES  | BTREE      |         |               |
| customers |          1 | customerName           |            1 | customerName           | NULL      |        NULL |     NULL | NULL   |      | FULLTEXT   |         |               |
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Last updated