You get the current value of a generator by calling GEN_ID( <gen-name>, 0 ).
Incrementing by zero doesn't actually change its value and returns the
current value.

You can't actually delete the generator itself. You can delete the record in
the system table that indicates its existance but the space it takes is not
reclaimable until after a backup and restore.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Sindu" <sindu@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, March 19, 2001 10:02 PM
Subject: [ib-support] generator question


> Hi all,
> Just wondering where the current generator value is kept. It's not in
> rdb$generators. And if I'd like to delete a generator, the manual said
> just delete from rdb$generators, is that all?
>
> TIA,
> sindu