ALTER SEQUENCE statement
Available since: v3.0.0
The ALTER SEQUENCE statement is used to modify a defined sequence.
SurrealQL Syntax
ALTER SEQUENCE [ IF EXISTS ] @name [ TIMEOUT @duration ]
Examples
The timeout of a sequence can be modified via an ALTER SEQUENCE statement. For example, a sequence can be included in the schema but effectively disabled if given a timeout of 0ns, after which ALTER SEQUENCE can be used to modify the timeout to make it available.
DEFINE SEQUENCE mySeq3 BATCH 1000 START 100 TIMEOUT 0ns;
INFO FOR DB.sequences;
sequence::nextval('mySeq3');
ALTER SEQUENCE mySeq3 TIMEOUT 100ms;
sequence::nextval('mySeq3');
Output
{ mySeq3: 'DEFINE SEQUENCE mySeq3 BATCH 1000 START 100 TIMEOUT 0ns' },
'Thrown error: The query was not executed because it exceeded the timeout: 0ns'
100
See also
