Re: column populated from sequence
From: Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
Date: Mon, 26 Nov 2001 20:59:32 +0100
Message-ID: <9tuf3i$1ph9$2_at_as201.hinet.hr>
Date: Mon, 26 Nov 2001 20:59:32 +0100
Message-ID: <9tuf3i$1ph9$2_at_as201.hinet.hr>
I'm not sure that I understand this well. How table's column default value could be referenced from sequence?
-- Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR> "Matt B." <gtimatt_at_home.com> wrote in message news:zajM7.25571$Sx.8173123_at_news1.elcjn1.sdca.home.com...Received on Mon Nov 26 2001 - 20:59:32 CET
> "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
> value assigned to it and that value might come from a sequence.
>
> -Matt
>
>