Subject | Re: [firebird-support] Is there a way to tell the order that rows were inserted? |
---|---|
Author | Martijn Tonies |
Post date | 2004-08-17T14:28:39Z |
Bob,
Without a primary key, how can you identify a row?
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Stupid question, I know, but I've gotta ask:nor
>
> 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,
> 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. WillWith regards,
> rdb$db_key allow me to ascertain the order?
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com