SHOW CREATE INDEX
New in v0.4.0.
SHOW CREATE INDEX returns the DDL statement used to create the index.
Syntax
| Field | Use |
|---|---|
| index_name | The index you want use. You can find available index names through SHOW INDEXES. |
Examples
SHOW INDEXES FROM my_view;
name
-------------
my_view_idx
SHOW CREATE INDEX my_view_index;
Index | Create Index
-------------------------------|---------------------------------------------------------------------------
materialize.public.my_view_idx | CREATE INDEX "my_view_idx" ON "materialize"."public"."my_view" ("a", "b");