Re: column populated from sequence
From: Matt B. <gtimatt_at_home.com>
Date: Mon, 26 Nov 2001 04:03:43 GMT
Message-ID: <zajM7.25571$Sx.8173123_at_news1.elcjn1.sdca.home.com>
Date: Mon, 26 Nov 2001 04:03:43 GMT
Message-ID: <zajM7.25571$Sx.8173123_at_news1.elcjn1.sdca.home.com>
[Quoted] "Jim Kennedy" <kennedy-family_at_home.com> wrote in message
news:xQeM7.77973$XJ4.41893655_at_news1.sttln1.wa.home.com...
> I would look in the trigger on the table specifically the insert trigger.
> Then I would take a look at the names of the sequences to see if someone
> used a reasonable naming convention.
> Then I would look to see if I could narrow down the choices based upon the
> highest value in the column and the next value in a sequence (assuming very
> few people are using the application at that time.)
> Jim
Also look in the data dictionary to see if the table's column has a default [Quoted] value assigned to it and that value might come from a sequence.
-Matt Received on Mon Nov 26 2001 - 05:03:43 CET