> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/show-index-from-table.md).

# 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   |         |               |
+-----------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
```