ContextQMD
Back to Materialize

SHOW CREATE INDEX

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

1231.1 KB
Original Source

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

Syntax

sql
SHOW [REDACTED] CREATE INDEX <index_name>;

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

For available index names, see SHOW INDEXES.

Examples

mzsql
SHOW INDEXES FROM my_view;
nofmt
     name    | on  | cluster    | key
-------------+-----+------------+--------------------------------------------
 my_view_idx | t   | quickstart | {a, b}
mzsql
SHOW CREATE INDEX my_view_idx;
nofmt
              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-headless "/headless/sql-command-privileges/show-create-index" %}}