Materialize Logo

SHOW CREATE INDEX

New in v0.4.0.

SHOW CREATE INDEX returns the CREATE INDEX statement used to create the index.

Syntax

SHOW CREATE INDEX index_name
Field Use
index_name The index you want use. You can find available index names through SHOW INDEXES.

Examples

SHOW INDEXES FROM my_view
   INDEXES
-------------
 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");