Subject Re: [firebird-support] Is there a way to tell the order that rows were inserted?
Author Martijn Tonies
Bob,


> Stupid question, I know, but I've gotta ask:
>
> I've got a table with a couple hundred thousand rows in it. There was no
> need for a primary key on the table when it was created a few years ago,
nor
> is there a timestamp column.

There's _always_ a need for a primary key :-)

Without a primary key, how can you identify a row?

> I have a need to know the order in which the rows were inserted. Will
> rdb$db_key allow me to ascertain the order?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com