Skip to main content

Alter Table Specification Field

Update the value of a single field in the definition of a table. The table's own fields and its persistence mappings are left unchanged.

Syntax​

alter table <table reference> set <table spec field name> <value>

Parameters​

table reference​

String — Name of the table to alter, optionally qualified by a schema name.

table spec field name​

String — A field from the table specification. Nested fields can be set using dot notation, and field names are matched case-insensitively.

value​

String, Number, Boolean, JSON, or List — The new value for the field. Strings must be quoted. Use none to clear a field that is optional in the specification.