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"),
","
),
")"
)
)
);
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified November 9, 2021: Add CHECK (10b7e10)