Switch to: V9V8V7V6V5

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;