CREATE INDEX

Define a new index

Synopsis

CREATE INDEX statement

Diagram(
  Stack(
    Sequence("CREATE", Optional("UNIQUE", "skip"), "INDEX"),
    Choice(
      0,
      Optional("index-name"),
      Sequence("IF", "NOT", "EXISTS", "index-name")
    ),
    Sequence(
      "ON",
      "table-name",
      "(",
      OneOrMore(
        Link("field-path", "/docs/essentials/expressions/#field-path"),
        ","
      ),
      ")"
    )
  )
);

Last modified November 9, 2021: Add CHECK (10b7e10)