ALTER SEQUENCE

The ALTER statement can be used to change authentication access and behaviour, global parameters, table configurations, table events, schema definitions, and indexes.

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

-------- Query --------
{ mySeq3: 'DEFINE SEQUENCE mySeq3 BATCH 1000 START 100 TIMEOUT 0ns' },

-------- Query --------
'Thrown error: The query was not executed because it exceeded the timeout: 0ns'

-------- Query --------
100

Examples

See also