SHOW CREATE INDEX

SHOW CREATE INDEX展示创建标签或者边类型时使用的nGQL语句,其中包含索引的详细信息，例如其关联的属性。

语法

  1. SHOW CREATE {TAG | EDGE} INDEX <index_name>;

示例

用户可以先运行SHOW TAG INDEXES查看有哪些标签索引，然后用SHOW CREATE TAG INDEX查看指定索引的创建信息。

  1. nebula> SHOW TAG INDEXES;
  2. +------------------+
  3. | Names            |
  4. +------------------+
  5. | "player_index_0" |
  6. +------------------+
  7. | "player_index_1" |
  8. +------------------+
  10. nebula> SHOW CREATE TAG INDEX player_index_1;
  11. +------------------+--------------------------------------------------+
  12. | Tag Index Name   | Create Tag Index                                 |
  13. +------------------+--------------------------------------------------+
  14. | "player_index_1" | "CREATE TAG INDEX `player_index_1` ON `player` ( |
  15. |                  |  `name(20)`                                      |
  16. |                  | )"                                               |
  17. +------------------+--------------------------------------------------+

边类型索引可以用类似的方法查询：

  1. nebula> SHOW EDGE INDEXES;
  2. +----------------+
  3. | Names          |
  4. +----------------+
  5. | "index_follow" |
  6. +----------------+
  8. nebula> SHOW CREATE EDGE INDEX index index_follow;
  9. +-----------------+-------------------------------------------------+
  10. | Edge Index Name | Create Edge Index                               |
  11. +-----------------+-------------------------------------------------+
  12. | "index_follow"  | "CREATE EDGE INDEX `index_follow` ON `follow` ( |
  13. |                 |  `degree`                                       |
  14. |                 | )"                                              |
  15. +-----------------+-------------------------------------------------+