The history table can have multiple entries for a single ID so there is no
primary key for this table. It's mostly just there to serve as a change
log.

Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: Raymond Kennington [mailto:raymondwk@...]
> Sent: Thursday, December 02, 2004 7:40 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Why use HISTORY.RDB$DB_KEY instead of HISTORY.ID in
> KeyLinks?
>
>
>
> In the Contacts demo, the History query has in its KeyLinks:
> HISTORY.RDB$DB_KEY
>
> whereas I expected to see HISTORY.ID.
>
> Why is it done this way and which is better and why?
>
> Thanks.
> Raymond.
>