Skip to main content
Update records in Standard by appending the constraint name and new value to the table declaration. If you do not follow the constraint name and value with a filter query, all records in the table will have that constraint updated to the given value.

​
Format

  • CONST_NAME — the name of the constraint you want to update.
  • NEW_CONST_VAL — the new value to assign to that constraint.
  • ?<FILTER_PARAMS...> — an optional filter query to target specific records. Supports the same conditions and LIMIT syntax used in finding records.

​
Example

Update the year to 1984 for up to 4 green vehicles:
Always include a filter query and a LIMIT when updating records to avoid unintended mass updates across your entire table.