SHOW GENERATORS
From InterBase
Go Up to isql Command Reference
Lists all generators or displays information about a specified generator.
SHOW {GENERATORS | GENERATOR name};
| Argument | Description |
|---|---|
|
<name> |
Name of an existing generator in the current database |
Description: To see a list of existing generators, use SHOW GENERATORS. SHOW GENERATOR name displays information about the named generator in the current database. Output includes the name of the generator and its next value.
SHOW GENERATOR has a shorthand equivalent, SHOW GEN.
Example: The following example lists all generators and then shows information about EMP_NO_GEN:
SHOW GENERATORS;
Generator EMP_NO_GEN, Next value: 146
Generator CUST_NO_GEN, Next value: 1016
SHOW GENERATOR EMP_NO_GEN;
Generator EMP_NO_GEN, Next value: 146