更新日期:2024年09月11日
语法格式
SHOW INDEX FROM table_name [FROM database_name]
说明
该语句列出选定数据库中指定表的索引。
示例
列出test 数据库中指定表的索引。
gbase> USE test;
Query OK, 0 rows affected
gbase> CREATE TABLE t_index(a int, b varchar(10));
Query OK, 0 rows affected
gbase> CREATE INDEX idx_a ON t_index(a) USING HASH LOCAL;
Query OK, 0 rows affected
Records: 0 Duplicates: 0 Warnings: 0
gbase> SHOW INDEX FROM t_index FROM test;
+---------+------------+----------+--------------+-------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
+---------+------------+----------+--------------+-------------+
| t_index | 1 | idx_a | 1 | a |
+---------+------------+----------+--------------+-------------+
+-----------+-------------+----------+--------+------+
| Collation | Cardinality | Sub_part | Packed | Null |
+-----------+-------------+----------+--------+------+
| NULL | NULL | NULL | NULL | YES |
+-----------+-------------+----------+--------+------+
+------------+---------+
| Index_type | Comment |
+------------+---------+
| LOCAL HASH | |
+------------+---------+
1 row in set
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 803