MySQL 테이블 인덱스 보기

MySQL 에서 테이블의 인덱스를 보기 위한 구문

 

mysql> SHOW INDEX FROM tbl_name

 

 

 

mysql> show index from COMTNSYSTEMCNTC ;
+-----------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| Table           | Non_unique | Key_name           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
+-----------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| COMTNSYSTEMCNTC |          0 | PRIMARY            |            1 | CNTC_ID     | A         |           0 |     NULL |   NULL |      | BTREE      |         |               | YES     | NULL       |
| COMTNSYSTEMCNTC |          0 | COMTNSYSTEMCNTC_PK |            1 | CNTC_ID     | A         |           0 |     NULL |   NULL |      | BTREE      |         |               | YES     | NULL       |
+-----------------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
2 rows in set (0.00 sec)