Table of Contents
SHOW SEQUENCES
[NEW in v5.0]
SHOW SEQUENCES displays information about all sequences defined in the specified database.
Syntax
SHOW SEQUENCES [{FROM|OF} db_name]
Result Columns
- fld_name
The name of the CHECK constraint.
- fld_ID
The ID of Sequence.
- fld_is_temporary
TRUE if Sequence is temporary.
- fld_current_value
Current value of this sequence. int64.
- fld_start_value
Start value of this sequence. int64.
- fld_inc_value
Increment value of this sequence. int64.
- fld_min_value
Minimal allowed value of this sequence. int64.
- fld_max_value
Maximal allowed value of this sequence. int64.
- fld_do_circle
TRUE if sequence should do circle on reach of min/max boundary.
Examples
SHOW SEQUENCES FROM tblPerson; SHOW SEQUENCES FROM tblPerson FROM dbAccounting;