语法格式
SHOW INDEX FROM [database_name.]table_name;
示例
示例1:查看已创建的索引。
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 667
gbase> SHOW INDEX FROM test.tx1;
+-------+------------+----------+--------------+-------------+--------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation|
+-------+------------+----------+--------------+-------------+--------+
| tx1 | 1 | iaddr | 1 | a | NULL |
+-------+------------+----------+--------------+-------------+--------+
+-------------+----------+--------+------+-------------+---------+
| Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+----------+--------+------+-------------+---------+
| NULL | NULL | NULL | YES | GLOBAL HASH | |
+-------------+----------+--------+------+-------------+---------+
1 row in set