Materialize/doc/user/content/sql/show-create-index.md

---

title: "SHOW CREATE INDEX" description: "SHOW CREATE INDEX returns the statement used to create the index." menu: main:

parent: commands

---

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

Syntax

SHOW [REDACTED] CREATE INDEX <index_name>

{{< yaml-table data="show_create_redacted_option" >}}

For available index names, see SHOW INDEXES.

Examples

SHOW INDEXES FROM my_view;

     name    | on  | cluster    | key
-------------+-----+------------+--------------------------------------------
 my_view_idx | t   | quickstart | {a, b}

SHOW CREATE INDEX my_view_idx;

              name              |                                           create_sql
--------------------------------+------------------------------------------------------------------------------------------------
 materialize.public.my_view_idx | CREATE INDEX "my_view_idx" IN CLUSTER "default" ON "materialize"."public"."my_view" ("a", "b")

Privileges

The privileges required to execute this statement are:

{{< include-md file="shared-content/sql-command-privileges/show-create-index.md"

}}

Related pages

• SHOW INDEXES
• CREATE INDEX