Comment on page

SEQUENCE

Config path: /<database>/<schema>/sequence/<name>.yaml
Example:
start: 1
interval: 1
Schema
start (int) - starting value for sequence (default: 1)
interval (int) - sequence step (default: 1)
comment (str)
Usage notes
1.Start is applied on creation of sequence only. Existing sequences always retain their current value.
2.All sequences must be created explicitly and assigned to default_sequence of relevant table columns. It helps to preserve sequence value when table must be re-created to apply changes which cannot be applied via ALTER TABLE.
Links
​CREATE SEQUENCE​
​ALTER SEQUENCE​
​SHOW SEQUENCES​
​DESC SEQUENCE​
​Using Sequences​
​Parser & JSON Schema (GitHub)​

SECRET

SHARE (outbound)

Last modified 7d ago