Up Prev Next
From: Jay Listo <jay dot listo at gmail dot com>
Subject: Re: Probably Trivial: Finding Largest Primary Key used in Table
Date: Jul 1 2005 10:07AM
Thanks Michael and Darin,
For the purposes of a few code tables (which would be used for lookups
mainly)...I'll probably just need MAX(primary_key_col) + 1
Delegal, Darin wrote:
>If you are dealing with an algorithmically assigned key, it's fairly
>easy. The following statement just assumes you want to use the max value
>SELECT new_key_value = MAX(primary_key_col) + 1
>Then INSET the new record using the new_key_value returned from the
>If you are not using an algorithmically assigned key, then we'll need
>more information to help you.
>'When the customer demands the impossible, they will end
>up buying from the guy who offers them the impossible.
>And the results, though tragic, are sadly predictable.' - Robert A.
>From: firstname.lastname@example.org [mailto:email@example.com]
>On Behalf Of Jay Listo
>Sent: Thursday, June 30, 2005 7:16 AM
>Subject: Probably Trivial: Finding Largest Primary Key used in Table
>This may sound trivial...but I've been trying to find out how to find
>the largest primary key that's been assigned/used within a table.
>I'm new to DB development while I have done some DBA.
>It would save me trouble when I want to keep control of the primary
>keys, make sure that when I insert a new record I can assign a unique
>I would like to do this using a perl script...not as some stored
>procedure or constraint so as to keep it as DB independent (regardless
>of Sybase, MySQL, Oracle, etc) as possible.