表索引 #
| 语法 | 描述 | 类型 |
|---|---|---|
| SHOW TABLE INDEX tableName [, tableName] … [FROM databaseName] | 查看物理表索引 | RQL |
1. 查看单表索引 #
SHOW TABLE INDEX tableName [FROM databaseName]
示例
mysql> SHOW TABLE INDEX t_user;
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
| database_name | schema_name | table_name | name | value |
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
| sharding_db | | t_user | uk_username | {"name":"uk_username","columns":["username"],"unique":true} |
| sharding_db | | t_user | PRIMARY | {"name":"PRIMARY","columns":["user_id"],"unique":true} |
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
2 rows in set (0.053 sec)
2. 查看多表索引 #
SHOW TABLE INDEX tableName [, tableName] … [FROM databaseName]
示例
mysql> SHOW TABLE INDEX t_order, t_user;
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
| database_name | schema_name | table_name | name | value |
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
| sharding_db | | t_order | PRIMARY | {"name":"PRIMARY","columns":["order_id"],"unique":true} |
| sharding_db | | t_user | uk_username | {"name":"uk_username","columns":["username"],"unique":true} |
| sharding_db | | t_user | PRIMARY | {"name":"PRIMARY","columns":["user_id"],"unique":true} |
+---------------+-------------+------------+-------------+-------------------------------------------------------------+
3 rows in set (0.064 sec)
输出说明
| 列 | 说明 |
|---|---|
| database_name | 逻辑库名称 |
| schema_name | 模式名称 |
| table_name | 表名称 |
| name | 索引名称 |
| value | 索引信息 |