Subject Re: [firebird-support] Re: Firebird record number
Author Ann W. Harrison
Alexandre Benson Smith wrote:

>
> Firebird has RDB$KEY virtual column that identifies a row uniquely
> across a database, Google for RDB$KEY and read the Claudios articles
> about it.

I strongly recommend that you not even consider using RDB$DB_KEY for
this application. It is a physical record identifier that will change
if you back up and restore the database. If a record is deleted in
normal operation, its db_key will be reused.


Regards,


Ann