ALTER TABLE
Manage tables and table constraints
Synopsis
ALTER TABLE statement
Diagram(
Stack(
Sequence("ALTER", "TABLE", "table-name"),
Choice(
0,
Sequence("RENAME", "TO", "new-table-name"),
Sequence("ADD", "FIELD", Link("field-definition"))
)
)
);
Field definition
Diagram(
Sequence(Link("field-path", "/docs/essentials/expressions/#field-path")),
OptionalSequence("type-name", OneOrMore(Link("field-constraint")))
);
Field constraint
Diagram(
Choice(
0,
Sequence("PRIMARY", "KEY"),
Sequence("UNIQUE"),
Sequence("NOT", "NULL"),
Sequence(
"DEFAULT",
Choice(
0,
Sequence("(", Link("expr", "/docs/essentials/expressions"), ")"),
Sequence(Link("expr", "/docs/essentials/expressions"))
)
)
)
);
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)