SHOW CREATE INDEX¶
SHOW CREATE INDEX shows the statement used when creating a tag or an edge type. It contains detailed information about the index, such as its associated properties.
Syntax¶
ngql
SHOW CREATE {TAG | EDGE} INDEX <index_name>;
Examples¶
You can run SHOW TAG INDEXES to list all tag indexes, and then use SHOW CREATE TAG INDEX to show the information about the creation of the specified index.
```ngql nebula> SHOW TAG INDEXES; +------------------+----------+----------+ | Index Name | By Tag | Columns | +------------------+----------+----------+ | "player_index_0" | "player" | [] | | "player_index_1" | "player" | ["name"] | +------------------+----------+----------+
nebula> SHOW CREATE TAG INDEX player_index_1;
+------------------+--------------------------------------------------+
| Tag Index Name | Create Tag Index |
+------------------+--------------------------------------------------+
| "player_index_1" | "CREATE TAG INDEX player_index_1 ON player ( |
| | name(20) |
| | )" |
+------------------+--------------------------------------------------+
```
Edge indexes can be queried through a similar approach.
```ngql nebula> SHOW EDGE INDEXES; +----------------+----------+---------+ | Index Name | By Edge | Columns | +----------------+----------+---------+ | "follow_index" | "follow" | [] | +----------------+----------+---------+
nebula> SHOW CREATE EDGE INDEX follow_index;
+-----------------+-------------------------------------------------+
| Edge Index Name | Create Edge Index |
+-----------------+-------------------------------------------------+
| "follow_index" | "CREATE EDGE INDEX follow_index ON follow ( |
| | )" |
+-----------------+-------------------------------------------------+
```
Legacy version compatibility
In NebulaGraph 2.0.1, the SHOW TAG/EDGE INDEXES statement only returns Names.